Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

New Contributor III

Question on Pivot table

We have data till June 2017 and wanted to show data from July 2017 to Mar 2018 as Null Values in Pivot table

Values should not be Zero and they should be displayed as blank ( Null values )  for each month

Could you please suggest possible ways.. Data is not available for July 2017 to Mar 2018 Months


1 Reply

Re: Question on Pivot table

If you use a master calendar that includes the required month/year value, then a sum of a value in the fact table will return null for July 2017 onwards. Make sure you are not suppressing zeros and nulls (Properties | Presentation).

Community Browser