Discussion Board for collaboration regarding Qlik DataMarket.
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
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).