Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum Value from month to month period

Sum Value “From” month “To” month by 12 period.

I want to Sum my Value base on the month of the year and by 12 period month basis

Example my data as below:

Year    Month Value

2010   Jan         1

2010   Feb         2

2010   Mar         3

2010   Apr         4

.

.

.

.

2011   Jan         13

2011   Feb         14

2011   Mar         15

2011   Apr          16

.

.

.

2012   Jan         25

2012   Feb        26

2012   Mar        27

2012   Apr         28

When I select 2012 Apr and system able to calculate sum the value by 2012 Apr from 2012 April until 2011 May And for 2012 Mar value will be sum from 2012 Mar until 2011 April and same with following months by 12 period basis

Sample format output:

2011May         2011Jun          2011Jul           2011Aug          2011Sep          2011Oct          2011Nov         2011Dec            2012Jan          2012Feb          2012Mar          2010Apr

138                         150                         162                              174                         186                             198                          210                            222                               234                           246                            258                          270

Many Thank

2 Replies
Not applicable
Author

See if this thread is Useful to U.

http://community.qlik.com/message/188652#188652

stantrolav
Partner - Creator II
Partner - Creator II

It's not so usefull.

The task is to make countig for Artificially created year by selected month.

When I select 2012, April system must to calculate sum of value from 2011 May to 2012 April.

If I select 2011 and 2012, April system must to calculate sum of value

from 2011 May to 2012 April in first bar named 2012

and

from 2010 May to 2011 April in second bar named 2011


MAT_from_to.qvw