I am trying to chance the default value for missing data from '-' to 0
For example, in this pivot table the dimensions on the left has only data in some years.
The other years give a '-' , I want to change that to the number zero
Because the there is no data the IF (ISNULL ... or IF(LEN( .... trick is not a solution.
In Qlikview it can be done on the presentation tab.
But I can not find this setting in Qlik Sense.
It is not possible as of now, because there is no setting available do to that.
You should look for some extensions from Branch.Qlik.com
You can use the Alt function in qlik. But this will work if your output is a numeric format.
Dimension : Year
Measure : Alt ( Sum(Sales) , 0 )
This will give zero as the output if the value is a '-'
Alt() is good for nulls, but will not help for missing values. Missing values are never calculated.
You can reproduce this situation with any 2 dimensions and any expression.
As long as there are missing values it shows a '-' in a pivot table.
I would like the default not to be '-' but 0.
In your script; just use the map syntax:
map <<Your field that can contain nulls>> using Nullmap
For your Nullmap you can use a inline table: