topic Re: Data filtering in Data Movement & Streaming

Data filtering

QlikEnthusiast1 — Wed, 19 Mar 2025 21:48:59 GMT

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?

Re: Data filtering

QFabian — Tue, 17 Sep 2024 20:00:15 GMT

Hi @QlikEnthusiast1 , o couple of ideas :

WHERE

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

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

Re: Data filtering

QlikEnthusiast1 — Wed, 18 Sep 2024 05:39:40 GMT

okay, thanks