topic Re: Bug in Line Chart(area style) when data is 0 in QlikView

Bug in Line Chart(area style) when data is 0

uacg0009 — Wed, 24 Aug 2016 09:40:00 GMT

Hi everyone,

I met a problem when using the line chart(area style), I also saw some threads talking about this problem, but I don't know whether the bug is fixed or not.

You can see that for FFF, FFF only have Jan 2016 data, but in the line chart, it shows wrong.

I think it should be :

But it shouldn't show null value in Month and Companies. I tried many methods but I can't show it like what I want.

Could you please help with that?

Thanks.

Aiolos Zhao

P.S.:

https://community.qlik.com/message/513625

Help with line chart,please

Re: Bug in Line Chart(area style) when data is 0

agomes1971 — Wed, 24 Aug 2016 09:57:36 GMT

Please check your excel file for null and zero values not showing in the qvw file.

When I do supress zero values everything is OK.

HTH

André Gomes

Re: Bug in Line Chart(area style) when data is 0

Chanty4u — Wed, 24 Aug 2016 09:59:24 GMT

or else

you can check suppress when value is null in dimension tab aswell

Re: Bug in Line Chart(area style) when data is 0

uacg0009 — Thu, 25 Aug 2016 05:46:12 GMT

Thanks for reply and you can use my example qvw, if you suppress zero value, it will shows wrong like the first graph.

Re: Bug in Line Chart(area style) when data is 0

uacg0009 — Thu, 25 Aug 2016 05:47:31 GMT

Thanks for reply, I know in dimension tab there is a suppress when value is null checkbox, but if I check that, it will shows wrong graph, you can try it using my example qvw.