topic Re: Strange behavior in line chart in QlikView

Strange behavior in line chart

ramonarcusa36 — Wed, 21 Sep 2016 11:26:18 GMT

Hey guys.

Please, take a look at the very simple example I'm attaching.

I have a line chart representing the sales by month and product. For this example, I just have one product, which has been sold at only three months: 1, 4 and 9. However, I want QlikView to show every month of the year. I easily get that, but what strikes me the most is that the line never goes to zero in the remaining months.

Since my sales for this example are 100 for January, 60 for April and 80 for September, it seems as if I had sold around 90 in February and 70 in March, and this can lead to misunderstandings. I need the line to go down to zero in the months we haven't sold that product.

Is there any way to get this?

Thanks in advance!

Re: Strange behavior in line chart

Gysbert_Wassenaar — Wed, 21 Sep 2016 11:37:06 GMT

Try adding this to your script:

Right join(Sales)

LOAD 'P1' as Product, Month Resident Calendar;

Re: Strange behavior in line chart

Frank_Hartmann — Wed, 21 Sep 2016 11:37:59 GMT

you also could add a fixing line.

just add this expression:

=avg({1}Sales/Sales)

hope this helps

Re: Strange behavior in line chart

puttemans — Wed, 21 Sep 2016 13:45:47 GMT

Easiest way will be to add the months for product P and put them on '0'.

Or switch to using a bar-chart

Re: Strange behavior in line chart

puttemans — Wed, 21 Sep 2016 13:58:44 GMT

I found it,

Under chart properties, select Dimensions

Then select Product, and mark 'Suppress when value is Null

Regards,

Johan

Re: Strange behavior in line chart

ramonarcusa36 — Wed, 21 Sep 2016 14:33:56 GMT

Frank, your answer gave me a fantastic clue. It's enough to add an expression with this content: Null()

It seems like this is telling QlikView that it has an actual value for each month, even if it's a null value sometimes.

Then, I just added a Null() expression, set it to invisible, and that's all there is to it!

Thank you all for your quick and valuable responses!