
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Showing a day by day Date
I have a Date attribute formatted as such : DD/MM/YYYY
The values contained are for the days where data is present, which means the date values are not consecutive as in day 1,2,3 ....
They are as such: Day 1 then 3 then 10
It depends on when there is data available for that date.
I need to show in a chart the dates where there is no values associated too! I want all the dates so that when there are no values, the line chart would flat line (continuous straight line).
Can any one assist me with that?
Thank you in advance
- Tags:
- new_to_qlikview

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think you need to add a Master Calendar in your script to be able to do this. Have a look here: Creating A Master Calendar

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have already done so, but that didn't work. The output is still the same.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be in your chart you need to uncheck 'Suppress When Zero' option on the Presentation tab:


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See how to fill in missing values here: How to populate a sparsely populated field

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Phil,
Please Check below Blog post generating missing values:
How to populate a sparsely populated field
See below post also
If still unable to solve the issue,please post sample data,will try to help.
Regards
Neetha
