Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
How to achieve the below. It needs to be done on the front-end not backend.
Kind Regards.
After doing lot of R&D I have reached to the conclusion that it is not possible through front end.
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.
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
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.
After doing lot of R&D I have reached to the conclusion that it is not possible through front end.
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.