last three month value

[sagaraperera]

Dear All,

Kindly note that I am currently using the below appended “Selection Tool” to arrive at the sales value for the past 3 months.

YEAR= 2017/2018

MONTH= JAN/DEC/NOV  

(PLEASE REFER ATTACHMENT)     

The issue I am encountering is when I apply the said selection tool, the value includes the Jan 2017 figure as well

Hence please advise me as to how I could avoid in arriving at the unwanted figure (Jan 2017)

MY SCRIPT

LOAD BCOD,

     CLA_CODE,

     PRD_CODE,

     POLICY_NO,

     REF_NO,

     DATE(floor(MARKETING_DATE)) as  MARKETING_DATE,

      MDATE,

     YEAR,

     MONTH,

     NAME,

     ME_CODE,

     DATE(floor(TRN_DATE)) as  TRN_DATE,

     POL_PERIOD_FROM,

     SCCOD,

     CP,

     RS,

     TC,

     GROSSTOT as sales ,

     TYPE,

     N_R_NOS1,

     F_NOS2   

[jharke]

Could you close this thread, as it goes on with https://community.qlik.com/thread/291477

Maybe you can delete this one?