Set analysis is not working.Please help me.

[#1]

  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.

[Anonymous]

({<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 >}.

[#3]

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.

[v_iyyappan]

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,

[Clever_Anjos]

There´s no <> into set analysis operators

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

you should use -=  in this case