Discussion Board for collaboration on QlikView Layout & Visualizations.
I have sample data as shown below.
I want to create a straight table with country as dimension. I want to show sum sales for each country, but only the top 3 sales.
How to achieve this?
Go to Solution.
Maybe like this:
You can use Rank function.
=aggr(if(Rank(sum(Investment))<=3,Investment),Investment) (For calculating Top 3)
Which version of Qlik do you have?
There is an option (Dimension Limit) in the latest version that easily allow you to obtain what you need ...
Hi try like this:
Hope this will help you
If you interested in the distinct Top 3 values, try this in a chart with dimension Country:
=Rangesum( Max(Sale), Max(Sale,2),Max(Sale,3) )
none of these seem to work for me..
Hey, I don't get the desired result.. it sums up all the values.
That works perfectly. But is there an alternative using Rank function?(just to make it dynamic like if its top 10)