topic Re: Set analysis is not working.Please help me. in QlikView

Set analysis is not working.Please help me.

Wed, 25 Sep 2013 16:15:09 GMT

Is there anything wrong I am doing in the below set analysys.This is not working for me.Please help me.

SuIs there anything wrong in the below set analyasis.m({< WorkCurrentFlag={'Y'},
PtshpCurrentFlag={'Y'},
[Source Code]={'NFSC'},
[SECR_LVL_CD_1] <> {'INSURANCE','ANNUITY','ANNUITIES'},
SecondTransactonTypeCode={'FCR','FEE'},[GL Post Amount] * alt([Partnership Percent],1))

Thanks in advance.

Re: Set analysis is not working.Please help me.

Anonymous — Wed, 25 Sep 2013 16:35:37 GMT

({<WorkCurrentFlag={'Y'},PtshpCurrentFlag={'Y'},[Source Code]={'NFSC'},[SECR_LVL_CD_1]={"<> ('INSURANCE','ANNUITY','ANNUITIES')"},SecondTransactonTypeCode={'FCR','FEE'}>}[GL Post Amount] * alt([Partnership Percent],1))

try with this.

test of < or > always with an ={"< (values)"} and close the set with >}.

Re: Set analysis is not working.Please help me.

Wed, 25 Sep 2013 16:41:25 GMT

The <> "Diferent" sign does not exists in SetAnalysis.

SetAnalysis works with set, so you can't compare values, you can add or remove.

sum(

WorkCurrentFlag= {'Y'},
PtshpCurrentFlag= {'Y'},
[Source Code]= {'NFSC'},
[SECR_LVL_CD_1] -= {'INSURANCE','ANNUITY','ANNUITIES'},
SecondTransactonTypeCode={'FCR','FEE'}

[GL Post Amount])

QlikView will mark as error but is not.

Re: Set analysis is not working.Please help me.

v_iyyappan — Wed, 25 Sep 2013 17:02:55 GMT

Hi,

Try like this,

= Sum({< WorkCurrentFlag={'Y'},PtshpCurrentFlag={'Y'},

[Source Code]={'NFSC'}, [SECR_LVL_CD_1]-={'INSURANCE','ANNUITY','ANNUITIES'},

SecondTransactonTypeCode={'FCR','FEE'}>}[GL Post Amount] * Alt([Partnership Percent],1))

Regards,

Re: Set analysis is not working.Please help me.

Clever_Anjos — Wed, 25 Sep 2013 17:03:10 GMT

There´s no <> into set analysis operators

[SECR_LVL_CD_1] <> {'INSURANCE','ANNUITY','ANNUITIES'},

you should use -= in this case