Discussion Board for collaboration on QlikView Layout & Visualizations.
Hi All ,
I have a scenario where i have to show the Top 10 Clients Group Percentage and Others Percentage. Am able to show the others Percentage by enabling others in Dimension Limit.
Is there any option to show the Percentage of Top 10 Clients
Can you attach sample file and your expected output?
Something like this? Uses two expressions, aggr(rank()) and no dimension. Add a variable and a slider if you want to dynamically change the Top N.
Try like this
Dimension: Add calculated dimension - =IF (aggr(Rank(Sum(Amount)), Client) <= 10, 'Top 10', 'Others')
Expression: Sum(Sales) and select Relative option for getting percentage.
Hope this helps you.
So simple... Doh