https://community.qlik.com/t5/QlikView/WANT-TO-FORMULLA/m-p/1555910#M742540 Can you explain with example data what should be done and what the result should be? Wed, 13 Mar 2019 11:40:22 GMT Gysbert_Wassenaar 2019-03-13T11:40:22Z https://community.qlik.com/t5/QlikView/WANT-TO-FORMULLA/m-p/1555890#M742539 <P>Dear All,</P><P>i want a formula is using following scrip</P><P>LOAD BCOD,<BR />CLA_CODE,<BR />PRD_CODE,<BR />POLICY_NO,<BR />REF_NO,<BR />DATE(floor(MARKETING_DATE)) as MARKETING_DATE,<BR />HISTORY,<BR />//MARKETING_DATE,<BR />MDATE,<BR />YEAR,<BR />MONTH,<BR />NAME,<BR />ME_CODE,<BR />//TRN_DATE,<BR />DATE(floor(TRN_DATE)) as TRN_DATE,<BR />TRAN_YEAR,<BR />TRAN_MONTH,<BR />//POL_PERIOD_FROM,<BR />SCCOD,<BR />CP,<BR />RS,<BR />TC,<BR />PF,<BR />LIFE,<BR />VAT,<BR />CESS,<BR />NBL,<BR />GROSSTOT,<BR />TYPE,<BR />N_R_NOS1,<BR />F_NOS2,<BR />REFUND_TYP</P><P>&nbsp;</P><P>and i want&nbsp;</P><P>MARKETING_DATE(REFUND_TYP='R',POLICY_NO)&lt;MARKETING_DATE(REFUND_TYP='A',POLICY_NO) AS RE_ACTIVE</P><P>&nbsp;</P><P>THANKING YOU</P><P>SAGARA</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/WANT-TO-FORMULLA/m-p/1555890#M742539 sagaraperera 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/WANT-TO-FORMULLA/m-p/1555910#M742540 Can you explain with example data what should be done and what the result should be? Wed, 13 Mar 2019 11:40:22 GMT https://community.qlik.com/t5/QlikView/WANT-TO-FORMULLA/m-p/1555910#M742540 Gysbert_Wassenaar 2019-03-13T11:40:22Z