5 Replies Latest reply: Jun 5, 2018 11:18 AM by willem van der Plas RSS

    filters and NULL

    willem van der Plas

      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