https://community.qlik.com/t5/App-Development/Getting-the-evolution-of-top-N-values/m-p/1631814#M47030 <P>Hello,</P><P>I have a problem representing some data in Qlik Sense.</P><P>I have a list of operations associated with a cost, a customer and a customer category.</P><P>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.</P><P>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 :</P><UL><LI>There are way more data (~50000 operations, ~30000 customers)</LI><LI>There are about 15 fields</LI><LI>The user wants to see the evolution up to the top 100 customers</LI></UL><P>Of course, it has to adjust to the current selections so I can't really do it in the loading script.</P><P>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.</P><P>Thank you in advance !</P> Sun, 06 Oct 2019 12:25:44 GMT GClotault 2019-10-06T12:25:44Z https://community.qlik.com/t5/App-Development/Getting-the-evolution-of-top-N-values/m-p/1631814#M47030 <P>Hello,</P><P>I have a problem representing some data in Qlik Sense.</P><P>I have a list of operations associated with a cost, a customer and a customer category.</P><P>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.</P><P>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 :</P><UL><LI>There are way more data (~50000 operations, ~30000 customers)</LI><LI>There are about 15 fields</LI><LI>The user wants to see the evolution up to the top 100 customers</LI></UL><P>Of course, it has to adjust to the current selections so I can't really do it in the loading script.</P><P>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.</P><P>Thank you in advance !</P> Sun, 06 Oct 2019 12:25:44 GMT https://community.qlik.com/t5/App-Development/Getting-the-evolution-of-top-N-values/m-p/1631814#M47030 GClotault 2019-10-06T12:25:44Z