topic Re: Set Analysis question - AND or OR in QlikView

Set Analysis question - AND or OR

Mon, 16 May 2011 10:28:50 GMT

Hello,

I have a chart with the following expression:

 count(distinct{$ <SASTATUS.SA_STATUS_DESCRIPTION = {'Closed'},
      SATYPE.CATEGORY = {'Domestic'},
       PREM.REG_STATUS = {'N'},
        PREM.ENER_FLG = {'D'}>}MPRN.MPRN)

However, there is someone with more than one SA_STATUS_DESCRIPTION (he has one of Combined as well as Closed.)

My question is why is he not excluded? Does he need to meet SOME of the conditions or ALL of the conditions?

If it is searching for people that meet SOME of the conditions, then why are people with more than one

SATYPE.CATEGORY not appearing (for example).

Is there an order that needs to be applied?

Any advice gratefully received.

Thanks

Rachael

Re: Set Analysis question - AND or OR

gandalfgray — Mon, 16 May 2011 11:04:37 GMT

The data needs to meet all your conditions (it works like AND).

The order of the conditions is not important (in this case at least).

If "someone" has several SASTATUS.SA_STATUS_DESCRIPTION

what you get using your set statement is the records matching "Closed"

(and all of your other conditions)

Set Analysis question - AND or OR

perumal_41 — Mon, 16 May 2011 11:26:07 GMT

Try it .i don't know this is correct or not

count(distinct{$ <SASTATUS.SA_STATUS_DESCRIPTION = {'Closed'}, SATYPE.CATEGORY = {'Domestic','International'}, PREM.REG_STATUS = {'N'}, PREM.ENER_FLG = {'D'}>}MPRN.MPRN)

Set Analysis question - AND or OR

brenner_martina — Mon, 16 May 2011 11:42:29 GMT

Hi,

look in the helpfile for Set analysis and here for the operators +, -, * and /. You can combine your selections by adding conditions.