last three month value

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: last three month value

jharke — Thu, 15 Feb 2018 12:36:36 GMT

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

Maybe you can delete this one?