If as dimension on filter

[w0jt4z]

Hi,
i tried to use "if" as dimension.
=if (Not IsNull(field),1,0) and it works, I think.
I try to get that dimension on Filter Pane and it give me only one choice, "1", i can't choose the "0" in this condition on Filter Pane (doesn't appear on Filter).

Please Help!

Best Regards,
Wojciech

[Mauritz_SA · Accepted solution]

Hi Wojciech

Have you got access to the table in the load script? Then you can add

if(Not IsNull(field),1,0) as IsNotNullField

to the load script and then use IsNotNullField as the dimension in your filter.

You can have a look at https://community.qlik.com/t5/New-to-QlikView/How-to-select-BLANKS-or-lt-NULL-gt-values/m-p/275021.

Good luck!

Mauritz

[w0jt4z]

It works! 🙂
Thank You very much indeed!

Best Regards,
Wojciech