Qlikview equalant of sql please.

Tue, 24 Sep 2013 11:58:31 GMT

What is the qlikview equalant of below 2 sql.Please help me.

DT_ACCT.SRC_CD = 'NFSC')

AND (DT_SECR.SECR_LVL_CD_1 NOT IN ('INSURANCE', 'ANNUITY', 'ANNUITIES'))

AND (FT_ACCT_TRN.SCND_TRN_TY_CD IN ('FCR', 'FEE') as Reccurring

(DT_ACCT.SRC_CD = 'NFSC')

AND (DT_SECR.SECR_LVL_CD_1 NOT IN ('INSURANCE', 'ANNUITY', 'ANNUITIES'))

AND (FT_ACCT_TRN.SCND_TRN_TY_CD NOT IN ('FCR', 'FEE') as Nonreccuring

Thanks a lot.

Re: Qlikview equalant of sql please.

pgrenier — Tue, 24 Sep 2013 19:58:52 GMT

Hello,

If you wish, you may use the Match(text, expr [,expr2, ...]) to achieve both the IN and NOT IN verifications, such as:

Match([SECR_LVL_CD_1], 'INSURANCE', 'ANNUITY', 'ANNUITIES') = 0 /* Meaning not found */

Match([SCND_TRN_TY_CD], 'FCR', 'FEE') > 0 /* Will return either 1 or 2 if match is found */

Regards,

Philippe