topic Re: Calculate measures for top 20 registers in App Development

Calculate measures for top 20 registers

JohnIssue — Fri, 15 Nov 2024 20:56:10 GMT

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!

Re: Calculate measures for top 20 registers

F_B — Tue, 25 Jun 2024 08:26:40 GMT

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.

Re: Calculate measures for top 20 registers

JohnIssue — Tue, 25 Jun 2024 09:23:56 GMT

Hello F_B!

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