Data filtering

[QlikEnthusiast1]

I have a case where I need to filter the 'Status' column in my data to exclude the 'Cancelled' status. I used the formula WHERE Trim(Status) <> 'Cancelled', but it did not work. How can I resolve this problem?

[QFabian]

Hi @QlikEnthusiast1 , o couple of ideas :

WHERE

      Trim(upper(Status)) <> 'CANCELLED';

Where
      not match(UPPER(Status), 'OPEN', 'CLOSED', 'ETC');