Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show all months on chart, even for months without data

Customer wants a chart with all 12 months of the fiscal year, even if one or more months does not have data for the selections.

In the attached example, March is not shown because no data exists for March in the two fiscal years displayed in the chart. 

I'm not sure if this can be handled within the chart, or something needs to happen in scripting / data load to ensure data values at each possible selection.  I'm looking for your suggestions and examples. 

In the attached example, month is about the only selection criteria, but eventually three or four selection criteria will be used.

Thank you,

Steve

1 Solution

Accepted Solutions
MayilVahanan

HI

PFA

Presentation -> untick supress zero -values

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

HI

PFA

Presentation -> untick supress zero -values

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.