how can we suppress null values in qlik sense pivot table or replace all null values with zeroes

[gulshan_rohilla]

Hello everyone,

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

Thanks

[shivanandk]

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.

[gulshan_rohilla]

Hi Shivanand,

Thanks for you reply, already tried it but didn't work