Hello,
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.
Thank you in advance !