Is there any way to replace '-' by 0 in QS pivot table?
I have a measure to count the number of record by using count(1). But the zero count will be shown as '-' instead of 0 .
How to display 0 for these case?
@vvvvvvvvvv If the null value is generated due to missing data then you can't replace it. The only way then is to generate missing data in your table . Look at below link
if my table is like below
A B C
the pivot table would be like this (counting number of records)
B1 2 -
B2 - 1
But I want - to be 0
how to generate the missing data???
How to remove the NULLs here?
- IsNull(Measure) or Measure = 0 and make the color background & text as white doesn't work
- NUM(Measure,'#;-#;') shows nulls as '-'
We're now in 2023 - Qlik Sense May 2023 release