topic Re: Pivot Table in Qliksense - Color Missing Data or replace Missing data by zero in App Development

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

jaypadhya — Sat, 16 Nov 2024 21:26:40 GMT

Hope you are doing great.

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

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.

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

pradosh_thakur — Fri, 08 Feb 2019 15:35:23 GMT

I am not able to see your image.

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

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

jaypadhya — Fri, 08 Feb 2019 16:05:06 GMT

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

jaypadhya — Fri, 08 Feb 2019 16:05:39 GMT

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

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

pradosh_thakur — Fri, 08 Feb 2019 16:15:45 GMT

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

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

ShannonColleen — Mon, 18 May 2020 14:48:55 GMT

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?