Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Specialist
Specialist

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

qlikpahadi07
Specialist
Specialist

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

ashwanin
Specialist
Specialist

Yes, you have to post a sample of data .

Anonymous
Not applicable
Author

Excel File is attached

ashwanin
Specialist
Specialist

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 .

Anonymous
Not applicable
Author


Pls look in my question on top.

Anonymous
Not applicable
Author

Hi, it's not earlier today.

Anonymous
Not applicable
Author

Hi Ashwani,

do you have found the attched excel-file?

Regards
Stefan