Chart show zero when no data for date

[#1]

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?

[phaneendra_kunc]

Follow this...

QlikView Zero Line Fix – Infinity Insight Blog

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

[giakoum]

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

[Anonymous]

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

[sandeeps_hyd]

Hi,

How did you do it ?

Please let me know.