Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Chart

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

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Chart

Hi,

Try like this

Dimension: Month

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

Regards,

Jagan.

View solution in original post

7 Replies
MVP & Luminary
MVP & Luminary

Re: Chart

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


talk is cheap, supply exceeds demand
Not applicable

Re: Chart

Yes, I tried no change

t_chetirbok
Valued Contributor

Re: Chart

Hi!

find the attachment

I think it is that you want

MVP & Luminary
MVP & Luminary

Re: Chart

Hi,

Try like this

Dimension: Month

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

Regards,

Jagan.

View solution in original post

Re: Chart

try to check the show all values in the Dimension tab

MVP & Luminary
MVP & Luminary

Re: Chart

Please post a small qlikview document that demonstrates the problem.


talk is cheap, supply exceeds demand
smirkinaa
New Contributor III

Re: Chart

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.