topic Re: Calculate with values from 1 and 2 rows in QlikView

Calculate with values from 1 and 2 rows

Anonymous — Sun, 16 Mar 2014 17:37:54 GMT

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

Re: Calculate with values from 1 and 2 rows

jolivares — Sun, 16 Mar 2014 20:17:46 GMT

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

Re: Calculate with values from 1 and 2 rows

qlikpahadi07 — Mon, 17 Mar 2014 06:35:21 GMT

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

Re: Calculate with values from 1 and 2 rows

ashwanin — Mon, 17 Mar 2014 07:57:04 GMT

Yes, you have to post a sample of data .

Re: Calculate with values from 1 and 2 rows

Anonymous — Mon, 17 Mar 2014 14:10:54 GMT

Excel File is attached

Re: Calculate with values from 1 and 2 rows

ashwanin — Mon, 17 Mar 2014 14:30:52 GMT

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 .

Re: Calculate with values from 1 and 2 rows

Anonymous — Mon, 17 Mar 2014 14:34:44 GMT

Pls look in my question on top.

Re: Calculate with values from 1 and 2 rows

Anonymous — Mon, 17 Mar 2014 14:41:38 GMT

Hi, it's not earlier today.

Re: Calculate with values from 1 and 2 rows

Anonymous — Tue, 18 Mar 2014 15:43:23 GMT

Hi Ashwani,

do you have found the attched excel-file?

Regards
Stefan