Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Creator

## How to show highest sale and product name in text box?

HI Community,

I have product name and sales, I want to show highest sale and product name in text box . how can i achieve please help me.

Regards

Anji

1 Solution

Accepted Solutions
Partner - Champion III

Use the aggr() function. For example, if you do not want to make any further distinction (between years, or just for last or current year etc.), you can use this one to get the maximum sales:

=Max(Aggr(Sum(Sales), Product))

If you want to know the name of the product that did best, use this expression:

=FirstSortedValue(Product, -Aggr(Sum(Sales), Product))

If you want to find out why and how this works, you can read this highly instructive treatment: QlikView Technical Brief - AGGR.docx

6 Replies
Contributor III

Hello

You may use the following expression:

if ([highest sale]= max ([highest sale]), [product name] & ':' & [highest sale])

regards

Partner - Champion III

Use the aggr() function. For example, if you do not want to make any further distinction (between years, or just for last or current year etc.), you can use this one to get the maximum sales:

=Max(Aggr(Sum(Sales), Product))

If you want to know the name of the product that did best, use this expression:

=FirstSortedValue(Product, -Aggr(Sum(Sales), Product))

If you want to find out why and how this works, you can read this highly instructive treatment: QlikView Technical Brief - AGGR.docx

Specialist

For Product -

= firstsortedvalue(Product, Sales)

Thanks.

Specialist

= firstsortedvalue(Product, -Sales)

Creator

hi ..

i have top 2 product which has highest amount i use your query but this shows nothing

Partner - Creator II

Hi need help

FirstSortedValue(Product,aggr(sum(Sales),Product)) is not returning any name though FirstSortedValue(Product,-aggr(sum(Sales),Product)) is giving me the minimum sales product

PFA of the finance file used

Community Browser