SCENARIO

Fri, 14 Jun 2013 11:02:28 GMT

Hi All,

Can any one help, how to do in backend.

Value will be always calculated for last 12 months from the current selection today date and 1^st history date.

Let us take an example, if the first transaction had been taken place on 1^st January 2013 and we are calculating it in current month it should be calculated as below

Month Name	Jan 13	Feb 13	Mar 13	Apr 13	May 13
Value	10	0	5	0	20

In current month, Value will be sum of all month value and divided by the number of months passed.

= Sum( 10 + 0 + 5 + 0 +20) / 5 = 35/5 = 7

Thanks in Advance

topic SCENARIO in QlikView

SCENARIO