topic Re: How to convert QlikSense table sheet null values in App Development

How to convert QlikSense table sheet null values

qwebnm — Wed, 07 Dec 2022 07:53:42 GMT

In a QlikSense table sheet, I want to convert null values to 1 and all remaining values to 2.
I'm trying a lot, but I can't convert.

If you look at the sheet, only that column comes out dark.
Is it something other than null values?

Searching with a magnifying glass doesn't even come up with values

=If((Value=null()), 1,2)
=If((Value=Null), 1,2)
=If((Value=0), 1,2)
=If((Value='-'), 1,2)
=If(len(trim(Value))= 0, 1,2)

What should I do?
Let me know if you know how!

Thanks you!

Re: How to convert QlikSense table sheet null values

hic — Wed, 07 Dec 2022 08:41:34 GMT

It may well be that these are "missing values" - that the entire row is missing in a table. Then these combinations aren't included in the calculation algorithm.

See
https://community.qlik.com/t5/Design/The-Importance-of-Nothing/ba-p/1464900
https://community.qlik.com/t5/Design/NULL-The-Invisible-Nothing/ba-p/1467674

Re: How to convert QlikSense table sheet null values

RafaelBarrios — Wed, 07 Dec 2022 08:46:21 GMT

HI @qwebnm

you could try

if(isnull(Value),1,2)

Hope this works for you

Best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 😁

Re: How to convert QlikSense table sheet null values

qwebnm — Thu, 08 Dec 2022 06:33:09 GMT

It didn't work out.

Is there any other way?

Re: How to convert QlikSense table sheet null values

qwebnm — Thu, 08 Dec 2022 07:25:55 GMT

I read the message you sent, but I'm still not sure how to solve it.

Can you explain in a bit more detail?

please..