Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Button to Select Top n Values


I want to have a button that when pressed selects the top n values of a field but I also would really like a user to be able to input how many values and which of the fields (Cost, Revenue, Margin) it selects over.

In the button options I have tried 'Select in Field' but don't know what to put for the Search String. I also don't know how to incorporate inputs into a buttons functionality.

Any help would be much appreciated!

10 Replies
Master II
Master II

You can use

='(' & CONCAT(IF(AGGR(RANK(Sum(Sales)),Customer) <= 5,Customer),'|') & ')'

and you could create a variable in place of the <=5 so the user can dynamically select the Top N values

This will Select the Top 5 Customer based on Sales