Calculate measures for top 20 registers

[JohnIssue]

Hi there!

I am developing an app in Qlik Sense where I find a particular requirement. I have lots of bar charts, pie charts, dispersion plots, where I plot information related to a group of people. 

Each person has a 'mark'. So I just want to plot the information from the 20 top people. However, when I add a filter, the top 20 may change. Is it even possible? To limit the plot to the 20 top people in a dynamic way?

Thanks in advance!

[F_B]

Hi @JohnIssue ,

well, yes, it's possible, how to do it depends on your data model.

How do you calculate the top 20? Maybe the Rank() function is what you are looking for: Rank - chart function | Qlik Sense on Windows Help

You can use a Variable input from the Qlik Dashboard bundle to limit the visualization to top 20.

[JohnIssue]

Hello F_B!

Thanks for your answer. How could I limit a visualization data using an input variable?