How to convert QlikSense table sheet null values

[qwebnm]

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

<tested script>

=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!

[hic]

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

See also attached white paper.

[RafaelBarrios]

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! 😁

[qwebnm]

It didn't work out.

Is there any other way?

[qwebnm]

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