topic Re: Line Chart with Zero in QlikView

Line Chart with Zero

Wed, 17 Jun 2015 20:26:18 GMT

So I want to create a line chart but it has to handle zero values in months where we had no scratches in our fire department. Essentially when a user selects a year my chart it should display a line chart thru the twelve months and draws the line segments. There are some months we have no scratches so the chart skips that month and draws the wrong segement. I need it draw the line down to zero.

Can any one help. Attached is my data I am working with.

Thanks

~Norman

Re: Line Chart with Zero

sunny_talwar — Wed, 17 Jun 2015 20:37:29 GMT

Do you have a qvw which have the data loaded into it?? Seeing that will be more helpful, then just looking at the data.

Re: Line Chart with Zero

Wed, 17 Jun 2015 20:45:09 GMT

Here is my QVW filw.

Norm

Re: Line Chart with Zero

MarcoWedel — Wed, 17 Jun 2015 22:38:47 GMT

Hi,

one solution could be:

hope this helps

regards

Marco

Re: Line Chart with Zero

tschullo — Thu, 18 Jun 2015 15:07:42 GMT

You will need to create zero (or near zero) values for each month if no data available for that month.

if you put in a value of .001 but tell chart to round to whole numbers ot will show a data point of zero and get you the desired results.

You can add the "zero" month values in the script as a second load where no vales are found for a given month.