How can I write this below case statement in Qlikview.

[#1]

CASE WHEN

      SRC_CD = 'NFSC' AND

       SECR_LVL_CD_1 NOT IN ('INSURANCE', 'ANNUITY', 'ANNUITIES') AND
        SCND_TRN_TY_CD IN ('FCR', 'FEE') THEN 'AMC Recurring'

Thanks in advance.

[swuehl]

Maybe like

if( SRC_CD = 'NFSC' and not match(SECR_LVL_CD_1, 'INSURANCE','ANNUITY','ANNUITIES') and match(SCND_TRN_TY_CD,'FCR','FEE'), 'AMC Recurring')

[#3]

You could try this:

sum({< SRC_CD = {'NFSC'} , SECR_LVL_CD_1 -= {'INSURANCE', 'ANNUITY', 'ANNUITIES'} , SCND_TRN_TY_CD = {'FCR', 'FEE'}>} [AMC Recurring])

Best,

Matt

[Anonymous]

One more:

if(SRC_CD='NFSC'

     AND match(SECR_LVL_CD_1,'INSURANCE', 'ANNUITY', 'ANNUITIES')=0

     AND match(SCND_TRN_TY_CD,'FCR', 'FEE'),

'AMC Recurring') as FieldName