topic AW:Re: Line Chart visualisation in QlikView

Line Chart visualisation

Mon, 18 Oct 2010 17:10:49 GMT

Hi All,

In my QV Application I show volume (y-axis) and time (x-axis) and each a line for total volume.

In a second diagram (same axis), the line is distinguished by a specific dimention (customer, product).

The problem: if a single customer's volume is available not every month, QV draws a straight line between those two values, ever though there are no values in between.

Please see attached an example:

How can I show correct lines (with zero values) in the second diagram?

Line Chart visualisation

pover — Mon, 18 Oct 2010 17:18:08 GMT

In the Presentation tab disable the option to suppress zero values.

Regards.

Line Chart visualisation

Tue, 19 Oct 2010 09:07:16 GMT

Hi Karl,

I unticked the "surpress zero values", but it did not work. Does the continuous time axis cause this problem?

Please see attached QVW-Example.

Line Chart visualisation

pover — Tue, 19 Oct 2010 15:41:40 GMT

Daniel,

In theory, unticking the suppress missing values should give you your desired result because there doesn't exist a relation between the Item B and various weeks. There doesn't even exist a zero value. However, like in this case, the suppress missing value escapes my understanding or simply just doesn't work.

The workaround would be to create a zero quantity transaction for every date possible. How you do this depends on your data model and script. I've attached an example.

Regards.

AW:Re: Line Chart visualisation

Tue, 19 Oct 2010 16:42:50 GMT

Hi Karl,

presumably you are right, this feature does not work correctly.

Thanks for your proposal, but this creates some synthetic keys and for the real sript with 10000+ items and 1000+ dates the data set would become too large.

Regards, Daniel

AW:Re: Line Chart visualisation

johnw — Tue, 19 Oct 2010 22:31:06 GMT

I think this works as a general approach to these problems:

In script, if any values are missing, create a new table with all values of the dimension you want to see the zeroes for
On dimensions tab, show all values and suppress when value is null <-- edit: unnecessary, so removed
On presentation tab, uncheck suppress zero-values, uncheck suppress missing
On axes tab, checkmark continuous, set static min to min(Dimension), static max to max(Dimension)

It does appear to work with your example, if I understand what you want. #1 is satisfied by your calendar, #2 needs to be done, #3 is done, and #4 still needs a static min and max (so that selections affect what you see despite choosing to show all values).

I think QlikView should really support this sort of thing in a much simpler way. It's such a common type of chart, and the solution is anything but simple and obvious. And that's assuming I got it right - I had to review some earlier posts and examples and poke around to make sure I had it right, and I'm still not entirely confident.

Edit: I'm a little more confident now. I found a real application where I'd done this in almost exactly this way. Only one difference, which is that I didn't suppress nulls on the dimensions tab. Ah, yes, it's unnecessary. Nulls won't show up on a continuous axis, so there's no reason to suppress them on the dimension tab as well. Crossed that out above.

AW:Re: Line Chart visualisation

Wed, 20 Oct 2010 09:31:36 GMT

Thanks John,

It is somehow intricate, but it works fine!

Regards, Daniel