topic Re: WANT_TO_FORMULLA in QlikView

WANT_TO_FORMULLA

sagaraperera — Sat, 16 Nov 2024 04:11:29 GMT

Dear All,

i want a formula is using following scrip

LOAD BCOD,
CLA_CODE,
PRD_CODE,
POLICY_NO,
REF_NO,
DATE(floor(MARKETING_DATE)) as MARKETING_DATE,
HISTORY,
//MARKETING_DATE,
MDATE,
YEAR,
MONTH,
NAME,
ME_CODE,
//TRN_DATE,
DATE(floor(TRN_DATE)) as TRN_DATE,
TRAN_YEAR,
TRAN_MONTH,
//POL_PERIOD_FROM,
SCCOD,
CP,
RS,
TC,
PF,
LIFE,
VAT,
CESS,
NBL,
GROSSTOT,
TYPE,
N_R_NOS1,
F_NOS2,
REFUND_TYP

and i want

MARKETING_DATE(REFUND_TYP='R',POLICY_NO)<MARKETING_DATE(REFUND_TYP='A',POLICY_NO) AS RE_ACTIVE

THANKING YOU

SAGARA

Re: WANT_TO_FORMULLA

Sue_Macaluso — Wed, 13 Mar 2019 15:24:48 GMT

Is this for QlikView or Sense? I want to move it to the correct product forum. Thanks

Re: WANT_TO_FORMULLA

sagaraperera — Thu, 14 Mar 2019 03:12:36 GMT

Dear Sue This is a Qlikview Product, I want a 01 Marketing Date > 02 Marking Date sagara

Re: WANT_TO_FORMULLA

sagaraperera — Thu, 14 Mar 2019 06:21:51 GMT

Dear Sue This is a Qlikview Product, I want a 01 Marketing Date > 02 Marking Date sagara