Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
knightwriter
Creator III
Creator III

How do I show the most sold fruit in a text box?

Hi All,

How do I show the top selling fruit in a text box expression? 

I have the number but Im looking to show the actual fruit name thanks.

=if(rank(count([fruit]))=1,Count([fruit]))

Thank you 

 

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

=if(rank(count([fruit]))=1,[fruit])

or

=if(rank(count([fruit]))=1,[fruit] & ' = ' & Count([fruit]))

View solution in original post

1 Reply
m_woolf
Master II
Master II

=if(rank(count([fruit]))=1,[fruit])

or

=if(rank(count([fruit]))=1,[fruit] & ' = ' & Count([fruit]))