Subtract straight table values

[#1]

Hi community!

I have a table

All the columns are calculated. I would like to have one more row which would be subtraction of (row 1 - row 2)

So for example last column would be (4 817 352 - (-5 217 417)) is this possible in Qlikview straight table?

Thank you all and have a great weekend!

[trdandamudi]

You can use Below() function. Please see the attached file:

Example:

Amount - Below(Amount)

[#3]

Great! Is it also possible to subtract rows which aren't next to each other?

[maxgro · Accepted solution]

I think above and here a good manual

Missing Manual - Above() and Below()

[#5]

That's it! thanks guys!‌

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

[trdandamudi]

Please share a sample and the required output, so that we can take a look and come up with a solution if possible.