Top 5 sub totals in qliksense - Qlik Community

Anonymous · ‎2017-07-20

Hi all,

I'm facing an issue where in to get sum of top n values. I'm able to restrict the values while showing but coming to summing the top n values, Sum is calculated to all the values. Request you to give me an idea how to achieve it.

Anil_Babu_Samineni · ‎2017-07-20

Will you able to provide sample application

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-07-20

find the attachment,

In this if u see for sub Category wise i need top 3 and sum of that 3(66+45+65) in ABC Category,

here it is taking total sum instead of 3.

Anonymous · ‎2017-07-20

with

aggr(if(rank(sum(Qty))<=5,Sub Category)

,Category,Sub Category) expression i am getting the results,

but for some categories it is showing 2 sub categories even values are not same.

sunny_talwar · ‎2017-07-20

There is no sheets in the attached file... have you attached the right file?