Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do to display a 0 in pivot table instead of '- ' ???
As attached.
Hi
The issue there is clearly that your data has no relation to the categories in use, or the key field is incorrect.
Qlik naturally use null values to free up space and give you a better performance instead, as you might know null values are different than 0.
If you want to force QS showing zeros you can either fix your key field connecting both sources (or concatenation if that is the case) or use a For..next. For instance, this snippet will generate max 12 new entries:
FOR EACH vRegion IN 'North', 'South'
// emptyDataset:
LOAD
AddMonths(YearStart(Today(1),0,7),RecNo()-1) as YM,
0 as [Zero Values],
AutoGenerate (12);
NEXT vRegion
Hi
The issue there is clearly that your data has no relation to the categories in use, or the key field is incorrect.
Qlik naturally use null values to free up space and give you a better performance instead, as you might know null values are different than 0.
If you want to force QS showing zeros you can either fix your key field connecting both sources (or concatenation if that is the case) or use a For..next. For instance, this snippet will generate max 12 new entries:
FOR EACH vRegion IN 'North', 'South'
// emptyDataset:
LOAD
AddMonths(YearStart(Today(1),0,7),RecNo()-1) as YM,
0 as [Zero Values],
AutoGenerate (12);
NEXT vRegion