Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I write this below case statement in Qlikview.

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.

3 Replies
swuehl
MVP
MVP

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

Not applicable
Author

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

mov
Champion III
Champion III

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