Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subtract straight table values

Hi community!

I have a table

qlikki.PNG

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!

1 Solution

Accepted Solutions
maxgro
MVP
MVP

6 Replies
trdandamudi
Master II
Master II

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

Example:

Amount - Below(Amount)

Not applicable
Author

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

maxgro
MVP
MVP

I think above and here a good manual

Missing Manual - Above() and Below()

Not applicable
Author

That's it! thanks guys!‌

oknotsen
Master III
Master III

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 .

May you live in interesting times!
trdandamudi
Master II
Master II

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