topic Re: Set Analysis - AND condition in QlikView

Set Analysis - AND condition

Wed, 27 Mar 2013 10:13:10 GMT

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...

Wed, 27 Mar 2013 10:15:32 GMT

Hi,

Please can you attach your sample application ?

Sokkorn — Wed, 27 Mar 2013 10:21:17 GMT

Hi,

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

Regards,

Sokkorn

Wed, 27 Mar 2013 10:23:13 GMT

Try this:

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