Sum of Running Difference

[#1]

My Data looks something like this

Id	Name	Value
1	30A	12
2	40A	19
3	50A	24
4	5f	29
5	4g	35
6	4h	45

Now I want a measure which will be the sum of all the Differences that is

(19-12)+(24-19)+(29-24)+(35-29)+(45-35)
I am a newbie with Qlik please help in writing a query which helps solve this requirement

[jvishnuram]

Hi shashank,

use this expression,

Aggr((Sum(Value)-Above(Sum(Value))),Name)

[#3]

Hi Sunny, Anyway that I can Filter out just values that are like 'OA' in the above expression. When I filter out that would give me (19-12)+(24-19)

[sunny_talwar]

Is that 'OA' or '0A'? If its '0A' then you can try this expression:

=Sum(Aggr(Alt((Only({<Name = {'*0A'}>}Value) - Above(TOTAL Only({<Name = {'*0A'}>}Value))), 0), Id, Name, Value)) with Expression Total