Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III
‎2022-12-07 11:40 AM

Show Products with highest Averages in a text box

I want to show Products with highest average in a text box.

For example, if I have two products with the same highest average, then the text box should show two product names. If there are three highest, then show three names.

I tried the below expression but it works as per the number of items we define to show but not the highest average.

concat ( IF( aggr ( Rank(Avg(Number)),[Product])<=1, [Product] & chr(10)))

Labels (1)
Labels
290 Views
0 Likes
0 Replies