Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Scrip to display specific categories

Hi I am new to QV and i would like to write a query that will only bring in values that  do not equal to 'Closed' or "Deployed" or "Cancelled" status. Below is a script that i am using today:

Unresolved_Items:

load distinct status as unresolved_status,

status

resident sample_table

where status = 'New'

    or status = 'Accepted'

    or status = 'Awaiting Finance'

    or status = 'Awaiting Initial Approval'

    or status = 'Awaiting Requirements'

    or status = 'Awaiting Review'

    or status = 'Awaiting Test'

    or status = 'Detail Needed'

    or status = 'InProgress'

    or status = 'In Tax Review'

    or status = 'Verification'

    And status <> Null ();

Thank you for your help

1 Reply
whiteline
Master II
Master II

Hi.

Unresolved_Items:

load distinct

     status as unresolved_status,

     status

resident sample_table

where match(status,'Closed', 'Deployed' ,'Cancelled')=0 and not isnull(status);