Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gulshan_rohilla
New Contributor

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

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:-

q1.PNG

I want to replace all the '-' values with the Zeroes. Can you guys please help me, how to do it

Thanks

Tags (1)
2 Replies
shivanandk
Contributor II

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

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
New Contributor

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

Hi Shivanand,

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