WANT_TO_FORMULLA

[sagaraperera]

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

[Sue_Macaluso]

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

[sagaraperera]

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

[sagaraperera]

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