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?
You can use Rank function.
=aggr(if(Rank(sum(Investment))<=3,Investment),Investment) (For calculating Top 3)
none of these seem to work for me..
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
Hey, I don't get the desired result.. it sums up all the values.
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) )
That works perfectly. But is there an alternative using Rank function?(just to make it dynamic like if its top 10)
Maybe like this:
This is perfect... Thank you.
Retrieving data ...