Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

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)
0 Replies