Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
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
Highlighted

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

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

View solution in original post

6 Replies
Highlighted
Contributor III
Contributor III

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

Hello

You may use the following expression:

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


regards

Highlighted

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

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

View solution in original post

Highlighted
Specialist
Specialist

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

For Product -

= firstsortedvalue(Product, Sales)

Thanks.

Highlighted
Specialist
Specialist

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

= firstsortedvalue(Product, -Sales)

Highlighted
Contributor III
Contributor III

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

hi ..

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

Highlighted
Partner
Partner

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

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