Rolling months trend graph

vardhancse — Wed, 09 Dec 2015 17:48:32 GMT

Hi,

I have a small requirement, is that based on the month selected need to get the rolling 12 months and 24 months back trend .

Say for eg:

Selected month was october and year was 2015

so the trend graoh should show the actual from october 2015 and back till November 2014

Similarly based on the filter month and year the trend should display

data is as given below:

FiscalMonth	MonthName	FYMonth	FiscalYear	Actual
1	October	Oct-14	2014	10
2	November	Nov-14	2014	9
3	December	Dec-14	2014	8
4	January	Jan-14	2014	7
5	February	Feb-14	2014	6
6	March	Mar-14	2014	5
7	April	Apr-14	2014	5
8	May	May-14	2014	6
9	June	Jun-14	2014	7
10	July	Jul-14	2014	8
11	August	Aug-14	2014	9
12	September	Sep-14	2014	10
1	October	Oct-15	2015	1
2	November	Nov-15	2015	2
3	December	Dec-15	2015	3
4	January	Jan-15	2015	4
5	February	Feb-15	2015	5
6	March	Mar-15	2015	6
7	April	Apr-15	2015	6
8	May	May-15	2015	5
9	June	Jun-15	2015	4
10	July	Jul-15	2015	3
11	August	Aug-15	2015	2
12	September	Sep-15	2015	1

Applied dimension: FYMonth

Expression:

Sum

({<FiscalYear=,Quarter=,MonthName=,Date={">=$(=MonthStart(Max(DateFull),-11))<=$(=Date(Max(DateFull)))"},>}Actual)

But the required rolling moths data was not coming. can please help me out to get the same.

Re: Rolling months trend graph

sunny_talwar — Wed, 09 Dec 2015 18:29:42 GMT

What is the format of your date field? Is it the same one as this -> =MonthStart(Max(DateFull), -11) in a text box object? Secondly, do you have two fields? Date and DateFull or do you just have a typo?

topic Rolling months trend graph in QlikView

Rolling months trend graph

Re: Rolling months trend graph