filters and NULL

[thewillemzelluf]

Hello everyone,

I have a problem with filters. I made an IF statement to exclude a certain group. However, Qlik also excludes the NULL values (which I do not want, I only want to exclude a specific group). Below the statement:

if (room <> 'square', 'turnover', NULL ()) AS "turnover filter"

Thanks in advance!

Greetings, Willem

[sunny_talwar · Accepted solution]

May be try this

If(room <> 'square' or Len(Trim(room)) = 0, 'turnover', Null()) as "turnover filter"

[thewillemzelluf]

no, unfortunately, it does not work. he still does not take the null values

[agigliotti]

do you want to exclude only the room equal to square ?

[sunny_talwar]

Would you be able to share few rows of data with expected output?

[thewillemzelluf]

sorry i made a mistake, now it works