Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi Shivanand,
Thanks for you reply, already tried it but didn't work