Strange behavior in line chart

[ramonarcusa36]

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!

[Gysbert_Wassenaar]

Try adding this to your script:

Right join(Sales)

LOAD 'P1' as Product, Month Resident Calendar;

[Frank_Hartmann · Accepted solution]

you also could add a fixing line.

just add this expression:

=avg({1}Sales/Sales)

hope this helps

[puttemans]

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

Or switch to using a bar-chart

[puttemans]

I found it,

Under chart properties, select Dimensions

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

Regards,

Johan

[ramonarcusa36]

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!