Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am new to Qlik. So I am looking for a way, could be an expression to get the top 10 value with their corresponding rank numbers. Output should look like the table below with Comp B being the top performer.
Company Rank
Comp B 1
Comp C 2
Comp D 3
Comp A 4
Thank you so much!
Is Rank already a field? If so you can simply Limitation -> Fixed Number -> Top 10 -> untick show others
Thank you for the reply. So there is no rank field. There's only the amount per company. I only got the rank using rank(sum(amount)) but I need to show only the top 10 in the table. Is there a way for that? Thank you so much 🙂
It would be the same. In a straight table add company as dimension and sum(amount) as measure, then limit the dimension to top 10 as indicated above
Oh my gosh! That easy? HAHA Sorry, laughing at myself. Been trying to use expression, didn't realize there is this function! Thank you so much. You are awesome for helping a newbie!!! 🙂