In this tutorial, I will show you how you can use Rank function to display top N values in a pivot table.


Out of listed fund investments, our objective is to display top 5 Fund investments by the dollar amount.

 Important steps:

1.  Create a calculated dimension to display top N values

2.¬† Make sure that you check “Suppress when value is NULL” for the calculated dimension.

That’s it.


photo by: Glenz Tee

Want to become QlikView developer?
Enroll in my course at udemy


If you enjoyed this article, get email updates (it’s free).

Email Address:

Related Posts Plugin for WordPress, Blogger...