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!
Solved! Go to Solution.