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

Set Analysis - AND condition

Hi,

Please help me to get the count of Id's which have the records in Either 'On Hold' column OR 'Cancelled' Column...

I wrote the expression as below, but it is giving me only the data based on AND condition

Count({$<Month={'31/01/2013'},[On Hold]={1},[Cancelled]={1}>}[ID])

Please suggest me...

3 Replies
Not applicable

Re: Set Analysis - AND condition

Hi,

Please can you attach your sample application ?

Sokkorn
Honored Contributor

Re: Set Analysis - AND condition

Hi,

Try this Count({<[On Hold]={1}>+<[Cancelled]={1}>} [ID])

Regards,

Sokkorn

Not applicable

Re: Set Analysis - AND condition

Try this:

Count({$<Month={'31/01/2013'},[ID]={'On Hold','Cancelled'}>}[ID])

Community Browser