I have a problem representing some data in Qlik Sense.
I have a list of operations associated with a cost, a customer and a customer category.
I want to make a chart that shows the evolution of the total cost of the top N customers y category. The X axis is the number of top N customers and the Y axis is the sum of the total cost for these top N customers within the category.
I have put an example of what I want in the attachements ("Input" is what I have and "Output" is what I want) but there are some difference with the actual data :
There are way more data (~50000 operations, ~30000 customers)
There are about 15 fields
The user wants to see the evolution up to the top 100 customers
Of course, it has to adjust to the current selections so I can't really do it in the loading script.
I tried to work around Aggr and Rank functions and set analysis but I can't manage to do it. Any help would be greatly appreciated.
