Aggregated cumulative total with sort order

[muhammadraza]

Hello guys,

How to achieve the below. It needs to be done on the front-end not backend.

Kind Regards.

[hic]

This is a pareto analysis. It can be done but it can also mean quite complex expressions. See more on 

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497 
https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684 

[muhammadraza]

Thanks for the reply. I have gone through these articles but I in my case I have 2 dimensions and I don't have to create classes but instead I have to take (top) accounts from each entity representing 85%.  Also I need it in straight table object.

Following your article I have reached closer when I am putting cumulative total formula it is disturbing the rank (order) which is being used to calculate the 85 % top accounts. Attached is the qvf file.

The final output should be one straight table containing only those top accounts from entities representing 85% from each entity.

Regards.

[muhammadraza · Accepted solution]

After doing lot of R&D I have reached to the conclusion that it is not possible through front end.

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inter...

Sorting on y-values in charts or sorting by expression columns in straight tables is not allowed when chart inter-record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.