topic Re: Showing 0 values in continuous x-axis in QlikView

Showing 0 values in continuous x-axis

Wed, 25 Nov 2020 16:16:04 GMT

Hi, is there a way to force a line graph to dip to 0 value on a continuous x-axis? Right now I the data points are still connected - I know creating a year table containing all the years will do the trick, but I wonder if it can be done without this extra table? Attached is a qvw showing the situation. Thanks!

Re: Showing 0 values in continuous x-axis

sunny_talwar — Tue, 11 Oct 2016 15:40:57 GMT

I think if you add the missing years, it might work for you

LOAD * INLINE [

Year, Amount

2009, 10

2009, 20

2010, 40

2012, 20

2012, 60

2012, 40

2015, 100

2015, 20

];

Join

LOAD * Inline [

Year

2009

2010

2011

2012

2013

2014

2015

];

Re: Showing 0 values in continuous x-axis

Thu, 13 Oct 2016 02:24:29 GMT

Thanks for the prompt reply! So is there no way to do it on the UI settings without going to loading script?

Re: Showing 0 values in continuous x-axis

sunny_talwar — Thu, 13 Oct 2016 15:25:33 GMT

I don't think so. The data is not null, it is completely missing. See this link for more details:

NULL handling in QlikView

Re: Showing 0 values in continuous x-axis

Fri, 14 Oct 2016 09:01:38 GMT

Ok thanks!