how to convert if condition to set analysis.

[#1]

Hi All,

I want to convert  this if condition to set analysis.

if(Status='arias' and (Count( Status ) >1) ,Count ( DISTINCT Fac_no ))

thanks

Savi.

[SunilChauhan]

count({<Status={'arias'},Count( Status ) >1>} DISTINCT  Fac_no )

or

aggr(count({<Status={'arias'},Count( Status ) >1>} DISTINCT  Fac_no ),Fac_no )

hope this helps

[#3]

hi Sunil,

thanx Sunil. but this is not working , there is a mistake. can u fix it.

thanx

Savi.

[SunilChauhan · Accepted solution]

sorry

count({<Status={'arias'},Count( Status ) ={">1"}>} DISTINCT  Fac_no )

or

aggr(count({<Status={'arias'},Count( Status ) ={">1"}>} DISTINCT  Fac_no ),Fac_no )

hope this helps

[#5]

hi Sunil,

there is a mistake, can u check if u dont mind.

thanx Savi.

[stevedark]

Looking at the two bits of code (IF and Set Analysis) it would appear these will give different results.  In the instance with the IF statement a count of all Fac_no's will be given if any Status is greater than one.  In the set analysis example a count of Fac_no's where the status is greater than one will be given.

The later sounds more useful, but it is a different result.

- Steve

[SunilChauhan]

it s better you can upload a sample file.

[CELAMBARASAN]

Hi,

     Check with this

     Count ( {<Status={'arias'}>*<Status={"=Count(Status)>1"}>}DISTINCT Fac_no )

Celambarasan