Error in expression with multiple if conditions.

Tue, 24 Sep 2013 19:13:41 GMT

Is there anything wrong I am doing here?

I have to calulate the sum([GL Post Amount] * (alt([Partnership Percent],1))) for the below if conditions.

sum(IF([Source Code]='NFSC' ,
         IF(SECR_LVL_CD_1 <> 'INSURANCE',
          IF(SECR_LVL_CD_1 <> 'ANNUITY',
           IF(SECR_LVL_CD_1 <> 'ANNUITIES',
            IF(SecondTransactonTypeCode='FEE'))))),[GL Post Amount] * (alt([Partnership Percent],1)))

Thanks in adavance.

Re: Error in expression with multiple if conditions.

pgrenier — Tue, 24 Sep 2013 19:54:36 GMT

Good day,

One thing is for sure, you can easily simplify your expression:

Sum(If([Source Code]='NFSC' and Match([SECR_LVL_CD_1], 'INSURANCE','ANNUITY','ANNUITIES')=0 andSecondTransactonTypeCode='FEE', [GL Post Amount] * alt([Partnership Percent],1) ,0))

Regards,

Philippe

topic Error in expression with multiple if conditions. in QlikView

Error in expression with multiple if conditions.

Re: Error in expression with multiple if conditions.