Display all date dimensions even if there is no value for it

[#1]

Hi,

I want to display all Year/Month/Week and Date values in my pivot table, even if there are no values against a particular date ( in whcih case it will show 0). Currently, qlikview displays only those dates against which data is present.

I tried creating island table from master calendar as below

DateIsland:

Load Distinct(Date) as Is.Date,

Week as Is.Week,

Year as Is.Year,

Month as Is.Month,

Day as Is.Day,

WeekDay as Is.WeekDay

Resident MasterCalendar;

It successfully generated all date values in the report, however, same data value was populated against all dates uniformly which is incorrect.i.e  if 1 cell value was '10' against 1/3/2016, then '10' got populated against all date values.

Please refer to the attached screenshot for the report structure and guide me on how to proceed.

[Gysbert_Wassenaar]

Try changing your chart expression by adding this to it: + sum({<date>}0)