Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis is not working.Please help me.

  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.

4 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

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
Specialist
Specialist

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
Employee
Employee

There´s no <> into set analysis operators

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


you should use -=  in this case