Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

stefan_fischer
New Contributor II

Calculate with values from 1 and 2 rows

Hi,

two values before columns needed. In column SU there are default values. Column average will be calculated with 12 values of SU in column average52. In row 1 and 2 there is the average of 12 values from SU. In Row3 i need the value of Row1 and also in Row2. How can I get this value for calculating at Row3

Row1: (100  + 200  + 300 + 400 + 500 + 600 + 700 + 800 + 900 + 1.000 + 1.100 + 1.200) / 12 = 650

Row2: (100  + 200  + 300 + 400 + 500 + 600 + 700 + 800 + 900 + 1.000 + 1.100 + 1.200) / 12 = 650

Row3: Row1 and Row2 for calculation

Row4: Row2 and Row3 for calculation

Regards

Stefan

8 Replies
jolivares
Valued Contributor

Re: Calculate with values from 1 and 2 rows

Try to post a table with values you want at least 5 rows...  I can't understand what really you want.

qlikpahadi07
Valued Contributor

Re: Calculate with values from 1 and 2 rows

Please post a simple Output in Excel which make us more clear 

ashwanin
Valued Contributor

Re: Calculate with values from 1 and 2 rows

Yes, you have to post a sample of data .

stefan_fischer
New Contributor II

Re: Calculate with values from 1 and 2 rows

Excel File is attached

ashwanin
Valued Contributor

Re: Calculate with values from 1 and 2 rows

HI Stefan, Dont know, What happens here. But i am not able to find any attachment. I know this is the problem with my pc , bz this happens earlier today .

stefan_fischer
New Contributor II

Re: Calculate with values from 1 and 2 rows


Pls look in my question on top.

stefan_fischer
New Contributor II

Re: Calculate with values from 1 and 2 rows

Hi, it's not earlier today.

stefan_fischer
New Contributor II

Re: Calculate with values from 1 and 2 rows

Hi Ashwani,

do you have found the attched excel-file?

Regards
Stefan

Community Browser