Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
({<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 >}.
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.
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,
There´s no <> into set analysis operators
[SECR_LVL_CD_1] <> {'INSURANCE','ANNUITY','ANNUITIES'},
you should use -= in this case