Scrip to display specific categories

Mon, 10 Sep 2012 15:10:01 GMT

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

Re: Scrip to display specific categories

whiteline — Mon, 10 Sep 2012 18:25:30 GMT

Hi.

Unresolved_Items:

load distinct

status as unresolved_status,

status

resident sample_table

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

topic Re: Scrip to display specific categories in QlikView

Scrip to display specific categories

Re: Scrip to display specific categories