Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Question

Hi,

I've got two tables:

1.jpg

I'm strugling for a couple of hours to get the next result:

2.jpg

Could anyone give me a hint to get a sum in the lines 199, 299 and 399.

199 should be the sum of account 100>120

299 should be the sum of account 200>220

399 should be 199 + 399


Is this easy to do in QS?

1 Reply
sinanozdemir
Valued Contributor III

Re: Question

It is possible if you already have "A-Total", "B-Total", and "TOTAL" rows in place in your data model. You can use RangeSum() with Above() to achieve this:

Capture.PNG

Take a look at my expression.

Hope it helps.