Mathematical operation within same column

[#1]

Hi guys,

i asked that question previously but i realise that it was confusing.

Suppose i have the following table. Column X is created by having the the second row minus the first row in column 'Value'. How can that be done in a Qlikview straight table?

Business Value X

a 2 2

b 8 6

c 10 2

d 20 10

[Anonymous · Accepted solution]

Hi, you can use Inter record functions, like above() in this case.

[#3]

Genius! Thx heaps!