Pivot Table in Qliksense - Color Missing Data or replace Missing data by zero

[jaypadhya]

Hope you are doing great.

Would you happen to help me in replacing 'No data' values in Qliksense Pivot Table as

0.

These values are " no value" and NOT null so please keep that in mind. (Checking for null and replacing with zero does not work)

 

I just need to replace these Grey cells as 0 instead of a hyphen. I went through every single community discussion but not one is useful.

It says join can create records for which there is no data and hence they always are hyphen but I wish to replace them with 0.

Please help as it needs urgent attention.

[pradosh_thakur]

I am not able to see your image.

Have you tried
if(len(trim(expression))>0,expresion,0)

[jaypadhya]

Check the post again - I edit it and sent you the image as well

[pradosh_thakur]

did the len(trim()) worked? else try with alt(expression,0). I will have a look.

[ShannonColleen]

I have the same issue - neither of those solutions work for me.  This was so easy in Qlikview, to replace both missing and null values with 0 in a pivot table.  Is there really no simple solution in Qlik Sense?