topic Re: how to convert if condition to set analysis. in QlikView

how to convert if condition to set analysis.

Wed, 25 Apr 2012 08:11:55 GMT

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.

how to convert if condition to set analysis.

SunilChauhan — Wed, 25 Apr 2012 08:15:48 GMT

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

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

hope this helps

how to convert if condition to set analysis.

Wed, 25 Apr 2012 08:23:33 GMT

hi Sunil,

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

thanx

Savi.

Re: how to convert if condition to set analysis.

SunilChauhan — Wed, 25 Apr 2012 08:26:44 GMT

sorry

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

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

hope this helps

Re: how to convert if condition to set analysis.

Wed, 25 Apr 2012 09:06:06 GMT

hi Sunil,

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

thanx Savi.

Re: how to convert if condition to set analysis.

stevedark — Wed, 25 Apr 2012 09:06:24 GMT

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

Re: how to convert if condition to set analysis.

SunilChauhan — Wed, 25 Apr 2012 09:43:37 GMT

it s better you can upload a sample file.

Re: how to convert if condition to set analysis.

CELAMBARASAN — Wed, 25 Apr 2012 09:57:57 GMT

Hi,

Check with this

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

Celambarasan