topic Chart show zero when no data for date in QlikView

Chart show zero when no data for date

Sun, 05 Oct 2014 11:11:01 GMT

Hi,

I've attached a file that contains a simplified (and inline) version of my problem:

I have a selection in the script that gets me the cancels for the last week for each customer,

But, there are days when a customer did not have any cancelled orders.

I want to show a line chart that shows the number of cancels each day in the last week,

In order to have all of last week's dates I manually import the dates (in the file it's inline).

My problem is that, as can be seen in the file, the line continues between dates, even if there is one between that was supposed to down to 0.

The blue line was supposed to dip in: 01/09/2014 and 04/09/2014

The red line was supposed to dip in: 29/09/2014 and 02/10/2014

How can I do it?

Re: Chart show zero when no data for date

phaneendra_kunc — Sun, 05 Oct 2014 15:41:28 GMT

Follow this...

QlikView Zero Line Fix – Infinity Insight Blog

also there are numerous examples in community. Search for "missing data"

Re: Chart show zero when no data for date

giakoum — Sun, 05 Oct 2014 16:17:46 GMT

When there is no comment entry for a date / customer, what do you want the line to do? Go to zero?

Re: Chart show zero when no data for date

Anonymous — Sun, 05 Oct 2014 20:55:43 GMT

Hi,

See the attached qvw. It builds a table with counts per customer per date, so that you have data for all dates, even if there are no comments (cancellations) for that specific customer and date.

I hope this solves your problem, and if you have any questions, just ask

Re: Chart show zero when no data for date

sandeeps_hyd — Thu, 20 Dec 2018 11:51:21 GMT

Hi,

How did you do it ?

Please let me know.