Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagaraperera
Creator
Creator

WANT_TO_FORMULLA

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

 

 

1 Reply
Gysbert_Wassenaar

Can you explain with example data what should be done and what the result should be?

talk is cheap, supply exceeds demand