topic Re: How can I write this below case statement in Qlikview. in QlikView

How can I write this below case statement in Qlikview.

Thu, 23 Jan 2014 18:31:16 GMT

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 — Thu, 23 Jan 2014 18:34:14 GMT

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

Thu, 23 Jan 2014 18:36:54 GMT

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 — Thu, 23 Jan 2014 20:41:29 GMT

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