topic Re: Urgent help needed, How to calculate average of next 3 coming rows on the basis of dimensions on current row in QlikView

Help needed

Sat, 19 Nov 2011 08:51:06 GMT

Dear All,

I have a problem that I want to calculate the Average Amount of next 3 coming row in a straight table chart but 1 Dimension excluded, on every row like the table

I want to exclude the Dimension Design, SNo. in calculation of RangeAvg

Customer	Design	Machine	SNo.	Sales Amount	sum next 3 rows	Average
A	D-1	Mc-1	1	50	70	35
A	D-1	Mc-1	2	45	25	25
A	D-1	Mc-1	3	25	0	0
A	D-1	Mc-2	4	75	0	0
B	D-5	Mc-1	5	40	25	25
B	D-5	Mc-1	6	25	0	0
B	D-5	Mc-2	7	30	0	0
C	D-1	Mc-1	8	40	0	0
C	D-1	Mc-2	9	30	50	50
C	D-2	Mc-2	10	50	0	0
D	D-1	Mc-1	11	20	0	0

SNo. value of this column is comming from sql query [ Row_Number() ], it is a running no

Last column is my desired result

I am attaching QVW sample here

thanks & regars

Re: Urgent help needed, How to calculate average of next 3 coming rows on the basis of dimensions on current row

Sat, 19 Nov 2011 20:11:56 GMT

There is some discrepency in the data above and data in attachment. Anyhow this can be done using rangesum(below (expression),1,3) and rangeavg(below (expression),1,3). Attached the example using your attachment.

Kiran.

Re: Urgent help needed, How to calculate average of next 3 coming rows on the basis of dimensions on current row

Mon, 21 Nov 2011 07:42:03 GMT

hi, Kiran

thanks

Help needed

Mon, 21 Nov 2011 10:31:31 GMT

hi, kiran

can I exclude one or two dimensions when calculating rangeavg

thanks & regards

Help needed

Mon, 21 Nov 2011 10:32:49 GMT

Use Total <Dim1,Dim2> after the set analysis in the expression.

Kiran.

Re: Help needed

Mon, 21 Nov 2011 10:35:40 GMT

hi, kiran

thanks for very quick reply,

I am not aware with set analysis can you please describe it

Please tell me "Is there any document related to SET ANALYSIS"

thanks & regards

Re: Help needed

Mon, 21 Nov 2011 10:40:56 GMT

Enclosed the a quick update.

Kiran.

Re: Help needed

Mon, 21 Nov 2011 10:48:51 GMT

Hi, Kiran

thanks again for very quick reply but I found some thing is missing in the sample sanded by you, It the same sample as sanded by you earlier nothing new in it.

Please tell is there any document related to the Set Analysis, if yes then from where I can get it.

Thanks & Regards

Re: Help needed

Mon, 21 Nov 2011 10:58:06 GMT

After checking the document I found that there is not set analysis. So I just updated with total expression.

Kiran