topic Re: Subtract straight table values in QlikView

Subtract straight table values

Wed, 25 Nov 2020 16:16:04 GMT

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 — Sat, 09 Jul 2016 16:00:44 GMT

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

Example:

Amount - Below(Amount)

Sat, 09 Jul 2016 17:04:37 GMT

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

maxgro — Sat, 09 Jul 2016 17:08:47 GMT

I think above and here a good manual

Sat, 09 Jul 2016 17:59:48 GMT

That's it! thanks guys!‌

oknotsen — Sat, 09 Jul 2016 20:57:55 GMT

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 — Sat, 09 Jul 2016 21:11:59 GMT

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