topic Chart Value 0 when no data available in QlikView

Chart Value 0 when no data available

Tue, 02 Dec 2014 11:47:25 GMT

Hi,

I have a chart that shows the number of emails received in the last 24h, grouped by 10 minutes.

the data I load looks something like this:

date	emails
2/12/2014 11:10	3
2/12/2014 11:00	5
2/12/2014 10:50	7
2/12/2014 10:30	8
2/12/2014 10:20	5
2/12/2014 10:10	2
2/12/2014 10:00	1
2/12/2014 9:50	2
2/12/2014 9:40	7
2/12/2014 9:30	10

and so forth...

My problem is that in the graph it shows the lines connected be all of the data points, without it zeroing when there was no data (for example, 2/12/2014 10:40 does not exist in the current data).

To solve this, I have an external script that creates a csv file with all of the "date-time"s in the past 24h, but I don't know how to use it so the chart of # of emails over time would zero when no emails were received.

Thanks!

EDIT: I know about the default 'suppress zero value', it is not the case in here because it doesn't zero the data because there isn't any data of the time (the datetime 2/12/2014 10:40 does not exist to have the "count" value of 0)

Re: Chart Value 0 when no data available

rajeshvaswani77 — Tue, 02 Dec 2014 11:52:00 GMT

Hi,

Yes the zero will not show for line, you will have to change to bar chart, and its assumed zero there.

This is default QlikView behaviour.

thanks,

Rajesh Vaswani

Re: Chart Value 0 when no data available

rubenmarin — Tue, 02 Dec 2014 12:11:38 GMT

Hi, If you have unchecked the "supress zero value" and it doesn't show can be because there is no "date" value for 10:40, you can concatenate the external csv to your "values" table, ie:

concatenate (EmailsTableName)

LOAD date,

0 as emails

FROM ...csv where not exists(date, date) //-->Load only the dates not previously loaded

Hope this helps