Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
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