topic Re: LAST MONTH OF LAST YEAR in QlikView

LAST MONTH OF LAST YEAR

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

Hi , I have the following expression to obtain Last Year based on the selected Month:

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

But, when the selected Month = January, it does not change the Month.

The correct result should be November of the past year

arulsettu — Wed, 22 Feb 2017 11:08:45 GMT

try this

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

sagaraperera — Wed, 22 Feb 2017 11:31:19 GMT

Dear Mr.Arul

IT IS COME TO LAST YEAR SAME MONTH BUT I WANT TO LAST YEAR PREVIOUS MONTH VALUE

SELECT DEC 2016

I WANT

VALUE OF NOV 2015

SAGARA

arulsettu — Wed, 22 Feb 2017 11:34:34 GMT

maybe try this

use your date field

sum( {$<DATE_FIELD= {"$(=AddMonths(Max(DATE_FIELD),-13))"},DESCRIPTION= {'NRP'} >} [Actual])