O'Reilly logo

QlikView Unlocked by Andrew Dove, Roger Stone

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Making charts more readable

Occasionally, we have used Borchester Models' data to demonstrate certain ideas and features. Have a look at this script fragment:

Stock:
LOAD [Shop No], 
     [Product Code], 
     [On Hand]
FROM
[QlikView Unlocked Data.xlsx]
(ooxml, embedded labels, table is Stock);

What is required here is a chart showing stock levels by product across all shops. However, if we just let QlikView do the sorting, it will use Product Code, and we will see something similar to this:

Making charts more readable

This is okay, but it's not really helpful. As there's a scroll bar, we can't see what we have the most stock of—it might be B112, but unless we scroll across, we won't know. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required