Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikcheepirishe
Creator
Creator

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

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 NoValueRange
10.65
20.720.07
30.320.4
40.890.57
50.760.13
1.17Rangesum
5Range_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.

1 Reply
sunny_talwar