HELP ME WITH THE SCRIP ISSUE

[#1]

  Please help me with the below expression if I am doing anything wrong here.

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

[Carlos_Reyes]

You're missing the action to be performed when all those if's come true:

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',  HERE YOU MUST PLACE WHAT YOU WANT TO TO , AND HERE YOU MUST PLACE THE ELSE))))),[GL Post Amount] * (alt([Partnership Percent],1)))

[pgrenier · Accepted solution]

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 and SecondTransactonTypeCode='FEE', [GL Post Amount] * alt([Partnership Percent],1) ,0))

Regards,

Philippe

[#4]

You need to use SetAnalysis like this, and avoid to use alt function.

sum ({$<     [Source Code]={'NFSC' },
                   SECR_LVL_CD_1-={'INSURANCE','ANNUITY','ANNUITIES'},
                    SecondTransactonTypeCode={'FEE'}

          >}

[GL Post Amount] )

* alt([Partnership Percent],1)

[stabben23]

Hi, this is syntax, BUT you will have multiple hits in your if statment.

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

[#6]

Thank you very much.

[#7]

Set analysis is coming up with syntax error for not equal.

[#8]

That is not an error, its just the QlikView error check.