Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

thewillemzelluf
New Contributor II

filters and NULL

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: filters and NULL

May be try this

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

5 Replies
MVP
MVP

Re: filters and NULL

May be try this

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

thewillemzelluf
New Contributor II

Re: filters and NULL

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

agigliotti
Honored Contributor II

Re: filters and NULL

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

MVP
MVP

Re: filters and NULL

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

thewillemzelluf
New Contributor II

Re: filters and NULL

sorry i made a mistake, now it works