Accumulation and aggr to be calculated (Sample excel)

[Anonymous]

Hi

I have some complex calculation to be calculate in my chart can any one suggest any method to calcualte the below mention logic - i have excel with sample data for u r ref

a. Here I used the Ver_No and Period as a dimention

b. in Period 2010P12 Refers to Year 2010 P01 means Jan, P02 Means Feb and so on

Calculation Logic

1. Using the sum(Vol) i calcualted the vol of the records In Column C

2. Using the Range(above (sum(vol),0,Rowno())) - i calculated the cummulative of the vol in Column D

Now I need to calculate the target volume

Based on the value in the column D, i have to calculated the cummulative of the target vol

a. For Min version i dont have to calculate the vol

b. For version 1.1 = sum of accumulated vol of version 1.0, period - please refer the excel sheet u ll understand clearly

For Example

THIS IS FOR VER_NO - 1.2

-------------------------

Target Vol of 1.2, 2009p12 = sum of column d of (vol 1.0+vol1.1), 2009P12

Target Vol of 1.2, 2010p01 = sum of column d of (vol 1.0+vol1.1), 2010P01

Target Vol of 1.2, 2010p02 = sum of column d of (vol 1.0+vol1.1), 2010P02

THIS IS FOR VER_NO - 1.3

-------------------------

Target Vol of 1.3, 2009p12 = sum of column d of (vol 1.0+vol1.1+vOL1.2), 2009P12

Target Vol of 1.3, 2010p01 = sum of column d of (vol 1.0+vol1.1+VOL1.2), 2010P01

Target Vol of 1.3, 2010p02 = sum of column d of (vol 1.0+vol1.1+VOL1.2), 2010P02

Any one help me in this would be appriciated

Narayanan

[spsrk_84]

Hi,

i got the solution for your problem go through the logic in the attached file..

copy & paste this code ..ofcourse the source for this script is excel file

hope the problem is solved

Regards,

Ajay

[Anonymous]

Hi Ajay,

Thank u for giving the solution, i hope this solution ll suit for my application. Thank you for providing me a solution.

Narayanan

[Anonymous]

Hi ,

I have excel with some calculation logic, can any one help me to solve the calulation logic in qlik view. Awating for your solution. kinldy reply for this

Regards,

narayanan.k

[Anonymous]

hi can any one help me on the above issue.

Any suggession would be appriciated