just want to ask how to replace all null values in qlik sense pivot table with Zeroes. I have the following report attached below:-
I want to replace all the '-' values with the Zeroes. Can you guys please help me, how to do it
add the function Alt before the your expression.
For example Alt( sum(sales) , 0) replace sum(sales) with your expression. If your expression returns null, it will replace it with 0.
Thanks for you reply, already tried it but didn't work
Retrieving data ...