rank

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

Objective:

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

https://www.udemy.com/qlikview-developer-course/?couponCode=LearnQlikView


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

Email Address:

Related Posts Plugin for WordPress, Blogger...