Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
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?
Thanks
Hi,
Try like this
Dimension: Month
Expression =Sum(Sales) + (Sum({1} Sales) * 0)
Regards,
Jagan.
Have you tried disabling the Suppress Zero-Values and Suppress Missing options in the chart properties?
Yes, I tried no change
Hi!
find the attachment
I think it is that you want
Hi,
Try like this
Dimension: Month
Expression =Sum(Sales) + (Sum({1} Sales) * 0)
Regards,
Jagan.
try to check the show all values in the Dimension tab
Please post a small qlikview document that demonstrates the problem.
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());
MasterCalendarPrepared:
LOAD
$(vStartDate) + RowNo() as Date
AutoGenerate $(vEndDate) - $(vStartDate);
MasterCalendar:
LOAD
*,
Date(Date) as DatePresentation,
Year(Date) as DateYear,
Month(Date) as DateMonth,
MonthName(Date) as DatePeriod
Resident
MasterCalendarPrepared;
DROP Table MasterCalendarPrepared;
//
Then you can rename key field and establish connection between Master Calendar and fact table.