Subtract one row from another row and so on in Pivot table

qlikcheepirishe — Tue, 31 Jul 2018 10:03:17 GMT

Hi All,

I want to achieve standard deviation as per Business requirement. So that I want to first calculate rangesum for the value given with Product Category, Customer Name, Alloy, Temper, Gauge, Tage Name, Date and Monthname.

Rangesum = SUM(fabs(difference of upper value to Lower value))

Standard Deviation Business Formula = (Rangesum/(range_count-1))/1.128)

e.g.

Row No	Value	Range
1	0.65
2	0.72	0.07
3	0.32	0.4
4	0.89	0.57
5	0.76	0.13
		1.17	Rangesum
		5	Range_count

Subtract row no 1 - row no 2, row no 2 - row no 3 and so on to achieve rangesum i.e 1.17 in above image.

I have attached excel sheet for data value and screenshot of selection that I made.

As per my selection, rangesum will be 0.018 and standard deviation will 0.0080.

Please suggest backend or frontend logic for the same asap.

Re: Subtract one row from another row and so on in Pivot table

sunny_talwar — Tue, 31 Jul 2018 11:41:38 GMT

Check my response here

Subtract one row from another row and so on in Pivot table

topic Re: Subtract one row from another row and so on in Pivot table in QlikView

Subtract one row from another row and so on in Pivot table

Re: Subtract one row from another row and so on in Pivot table