Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
1 Reply
whiteline
Honored Contributor II

Re: Scrip to display specific categories

Hi.

Unresolved_Items:

load distinct

     status as unresolved_status,

     status

resident sample_table

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

Community Browser