This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
QlikView Zero Line Fix – Infinity Insight Blog
also there are numerous examples in community. Search for "missing data"
When there is no comment entry for a date / customer, what do you want the line to do? Go to zero?
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
How did you do it ?
Please let me know.