Chart

[#1]

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

[Gysbert_Wassenaar]

Have you tried disabling the Suppress Zero-Values and Suppress Missing options in the chart properties?

[#3]

Yes, I tried no change

[t_chetirbok]

Hi!

find the attachment

I think it is that you want

[jagan · Accepted solution]

Hi,

Try like this

Dimension: Month

Expression =Sum(Sales) + (Sum({1} Sales) * 0)

Regards,

Jagan.

[avinashelite]

try to check the show all values in the Dimension tab

[Gysbert_Wassenaar]

Please post a small qlikview document that demonstrates the problem.

[smirkinaa]

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.