topic Re: Please help me with the below expression. in QlikView

Please help me with the below expression.

Tue, 08 Oct 2013 17:47:11 GMT

I am using 3 sum satements to calcualte the sum where SECR_LVL_CD_1 is different for each of them.Can I use only one expression instead of 3 different expressions?

Sum(If( WorkCurrentFlag='Y'
and PtshpCurrentFlag='Y'
and [Source Code]='NFSC'
and Match(SecondTransactonTypeCode='FEE','FCR')=0
and [SECR_LVL_CD_1]='ANNUITY', [GL Post Amount] * alt([Partnership Percent],1)))

Sum(If( WorkCurrentFlag='Y'
and PtshpCurrentFlag='Y'
and [Source Code]='NFSC'
and Match(SecondTransactonTypeCode='FEE','FCR')=0
and [SECR_LVL_CD_1]='INSURANCE',[GL Post Amount] * alt([Partnership Percent],1)))

Sum(If( WorkCurrentFlag='Y'
and PtshpCurrentFlag='Y'
and [Source Code]='NFSC'
and Match(SecondTransactonTypeCode='FEE','FCR')=0
and [SECR_LVL_CD_1]='ANNUITIES',[GL Post Amount] * alt([Partnership Percent],1)))

Thanks in adavnce.

Re: Please help me with the below expression.

Gysbert_Wassenaar — Tue, 08 Oct 2013 17:51:50 GMT

I think this could replace it:

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

The expression editor doesn't understand -=, but that's a bug in the expression editor

(/me crosses his fingers that no quotes and parentheses are missing)

Re: Please help me with the below expression.

CELAMBARASAN — Tue, 08 Oct 2013 17:53:55 GMT

Try something like

Re: Please help me with the below expression.

Tue, 08 Oct 2013 17:57:18 GMT

SecondTransactonTypeCode -= {'FEE','FCR'} IS GIVING error.

Re: Please help me with the below expression.

CELAMBARASAN — Tue, 08 Oct 2013 18:09:16 GMT

It will underline as error but you will see expression ok. Some issue in the syntax checking.