month wise VALUE

[sagaraperera]

Dear All,

i want to get a last 03  month value  not add month field to chart. (WITHIN TWO YEARS TURNING POINT)

I WANT BELOW

JAN 2017 = VALUE

DEC 2016 VALUE

NOV 2016= VALUE

NOT USING BELOW

	YEAR	2016	2016	2017
BCOD	MONTH	11	12	1
CO01		26,315,373	22,448,666	21,284,113
CO02		3,085,912	1,867,994	4,292,186

I using given below expression

FIRSTLY I SELECT JAN 2017

01.  2017 JAN (CURENT MONTH) =  Sum ( {$<DESCRIPTION= {'GROSS_PREMIUM'},DESCRIPTION= {'NRP'} >} [Actual]) THIS ALREADY WORK

02.  2016 DEC = SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual])  THIS IS COME TO ZERO VALUE

03.  2016 NOV =SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) THIS IS A WORK

SECONDARY I SELECT FEB  2017

01.  2017 FEB (CURENT MONTH) =  Sum ( {$<DESCRIPTION= {'GROSS_PREMIUM'},DESCRIPTION= {'NRP'} >} [Actual]) THIS ALREADY WORK

02.  2016 JAN = SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual])  THIS IS A WORK

03.  2016 DEC =SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) THIS IS COME TO 2015 DEC VALUE

I USING INPUT BOX IT IS GIVEN BELOW

vMaxdate	=	01 Jan 2017
vPriorMonthYear	=	2016
vMindate	=	01 Jan 2017
prioryear	=	2016
vMaxDay	=	31
vPriorMonth	=	Dec
vPriorMonth-1	=	Nov
vPriorMonth-2	=	Oct
vPriorMonth-3	=	Sep
vPriorMonth-4	=	Aug
vPriorMonth-5	=	Jul
vPriorMonth-6	=	Jun
vPriorMonth-7	=	May
vPriorMonth-8	=	Apr
vPriorMonth-9	=	Mar
vPriorMonth-10	=	Feb
vPriorMonth-11	=	Jan
vPriorMonth-12	=	Dec
vPriorMonth-13	=	Nov
vNextMonth	=	Feb

PLEASE HELP ME

SAGARA

[nagarjuna_kotha]

Hi ,

Can U share sample application on the same

[nagarjuna_kotha]

It will be easier to solve issue...

-Nagarjun

[sagaraperera]

USING THIS

= SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual])  THIS IS COME TO ZERO VALUE

SECOND SELECTION - IT COME TO

=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) THIS IS OK VALUE (209,252,151)

THEN I USE SAME EXPRESSION

=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) THISCOME TO JAN 2015 VALUE (301,036,534)

VALUE 301036534 IS A 2015 JAN VALUE

PLEASE HELP

[ganeshsvm]

Hi Perera,

FYI,

Follow these links to upload a sample qvw.

• Uploading a Sample
• Preparing examples for Upload - Reduction and Data Scrambling

-Ganesh