topic Re: VALUE OF BACKWARD MONTH in QlikView

VALUE OF BACKWARD MONTH

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

Dear All,

I want to get a last year month value. it is may this

I selected Year 2016 and month December - I WANT GET A VALUE OF YEAR 2016 AND MONTH OF NOVEMBER VALUE

In this selection i get last year same month value using below

=sum( {$<TRAN_YEAR= {"$(=Only([TRAN_YEAR]-1))"},DESCRIPTION= {'NRP'} >} [Actual])

But i want to get a last year before month value it may this

PLEASE USE MY ATTACHMENT AND I WANT GET YELLOW COLOR COLUMN.

I already using Trandatecalender:

LOAD

DAY(TRAN_DATE) AS TRAN_DAY,

DATE(TRAN_DATE) AS TRAN_DATE,

DATE(monthstart(TRAN_DATE), 'MM-YYYY') as MONTH_YEAR,

WEEK(TRAN_DATE) AS TRAN_WEEK,

YEAR(TRAN_DATE) AS TRAN_YEAR,

MONTH(TRAN_DATE) AS TRAN_MONTH

RESIDENT PL;

Please can u help me get a

Thanking you

sagara

john9inno — Thu, 23 Feb 2017 04:22:14 GMT

this will work

sum( {$<TRAN_YEAR= {"$(=Only([TRAN_YEAR]-1))"},TRAN_MONTH= {"$(=Only([TRAN_MONTH]-1))"},DESCRIPTION= {'NRP'} >} [Actual])

Anil_Babu_Samineni — Thu, 23 Feb 2017 04:55:53 GMT

PLEASE USE MY ATTACHMENT AND I WANT GET YELLOW COLOR COLUMN.

I didn't found attached file over here

Please can u help me get a

Year 2015 and Month November value not a Year 2016 and Month of December Value.

From this, Usually it should like below

Sum({<Year = {'$(=Max(Year)-2)'}, Month = {'=$(=Max(Month)-1)'}, DESCRIPTION = {'NRP'}>}Sales)