Discussion Board for collaboration related to QlikView App Development.
I have created a Master Calendar but I don't have data for some months. Now I want to display blank even there is no data. How to achieve this?
Solved! Go to Solution.
Hi, you need to fill the gaps in your Master Calendar or you can create it without using fact table.
// example of creating Master Calendar
LET vStartDate = Num('01.01.2014');
LET vEndDate = Num(Today());
$(vStartDate) + RowNo() as Date
AutoGenerate $(vEndDate) - $(vStartDate);
Date(Date) as DatePresentation,
Year(Date) as DateYear,
Month(Date) as DateMonth,
MonthName(Date) as DatePeriod
DROP Table MasterCalendarPrepared;
Then you can rename key field and establish connection between Master Calendar and fact table.