Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try changing your chart expression by adding this to it: + sum({<date>}0)