Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Hello F_B!
Thanks for your answer. How could I limit a visualization data using an input variable?