Showing 0 values in continuous x-axis

[#1]

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!

[sunny_talwar · Accepted solution]

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

];

[#3]

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

[sunny_talwar]

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

NULL handling in QlikView

[#5]

Ok thanks!