Discussion Board for collaboration related to QlikView App Development.
I am using pivot table and I need 0's to be populated not the blanks. If I select the option suppress zeros then both are going.
how to get 0's not the blanks.
May be convert 0s to 0.00000001 and use dual function to display them as 0
try the below sample
Load * inline [
Create a straight table with DIM as dimension and below expression
Now E and H which have null values will be hidden and B and G which have zero values will still be shown
If you really have blanks (nulls), can you just change the Null Symbol to 0?
let me try