topic Re: Please help with Cumulative sales in App Development

Please help with Cumulative sales

Qlik1_User1 — Fri, 25 Jul 2025 04:37:46 GMT

Hi,

Please help with below query.
Country Product Sales

USA Motors 500

USA Spare 500

USA Keys 300

USA Tyres 200

USA Soaps 600

IND Soaps 300

IND Micher 200

IND Spare 500

IND Keys 400

UK Raw Parts 400

Re: Please help with Cumulative sales

MatheusC — Thu, 24 Jul 2025 19:07:28 GMT

You'll need the rank function.

Rank(Sum(Sales), 4) <= 3

For the value of the top 3 products in each country, you can work with the total() qualifier and the aggr().

Sum(Sales)
/
Sum(TOTAL <Country>aggr(If(Rank(Sum(Sales), 4) <= 3, Sum(Sales)),Country, Product))

- Matheus

Re: Please help with Cumulative sales

Oleg_Troyansky — Thu, 24 Jul 2025 19:22:30 GMT

Today is my lucky day! Every question I read, is covered as an exercise in my Qlik Expert class, or in my Advanced Development Techniques session at the Masters Summit for Qlik 🤣🤣🤣

To show top 3 products for each Country, I'd recommend the following calculated Dimension for the Product:

AGGR(IF(Rank(sum(Sales), 4) <= 3, Product), Country, Product)

Cheers,

Oleg Troyansky