Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
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

View solution in original post

1 Reply
MayilVahanan

HI

PFA

Presentation -> untick supress zero -values

Thanks & Regards,
Mayil Vahanan R