This content has been marked as final. Show 8 replies
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.