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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rank, Textbox, Set Analysis

I've 3 columns

Customer     Cust Rating     Item

A                 Great               Pen

A                 Good               Pencil
A                 Bad                 Eraser
A                 Great              Ink

B                 Great              Pen

B                 Good              Pen
B                 Bad                Pencil
B                 Avg                Eraser

I would like to show the Rank 1 item based on Great Customer Rating in a text box for all the customers.

For example, In the above table, Customer A & B ordered 8 products out of which they rated 'Great' 3 times. Pen was rated Great twice.

How can I show that in a text box and not a table?

1 Reply
sunny_talwar

May be something like this:

=FirstSortedValue(Item, -Aggr(Count(Item), Item))