Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart show zero when no data for date

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.

Capture.PNG.png

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?

4 Replies
phaneendra_kunc
Partner
Partner

Follow this...

QlikView Zero Line Fix – Infinity Insight Blog

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

giakoum
Partner
Partner

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

kimrormark
Creator
Creator

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
Contributor II
Contributor II

Hi,

How did you do it ?

Please let me know.