Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing 0 values in continuous x-axis

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!

1 Solution

Accepted Solutions
sunny_talwar

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

];

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

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

];

Capture.PNG

View solution in original post

Not applicable
Author

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

Not applicable
Author

Ok thanks!