Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable



I've got two tables:


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


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
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:


Take a look at my expression.

Hope it helps.