If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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???