Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Steps:
I am trying to get first 80% count,so that i need all the value to be in sorted order.
I don't understand
Check it here: The sortable Aggr function is finally here!
Yeah i know but i am working in Qlikview 11.20.Is it possible to achieve in qlikview 11.20
Unfortunately not. It's QV 12 onwards.
Is there any other approach to get values dynamically sorted
May be this blog can be helpful: Recipe for a Pareto Analysis
no chance with QV11, if you need the calculation completely in frontend...
how to do in backend
if you do it in backend, the calculation is fixed, means that the buckets (like A,B,C )won't change when selecting data from listboxes...
If this would be sufficient for you, please post some sample data and explain what you are expecting.
May be try this approach
Q-Tip # 11 – So How Many Customers Make Up Most of Your Sales? | Natural Synergies