Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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]))

View solution in original post