Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

[Solved]How can i get a single row

Please,

I need show a single row of Sales, i wanna show  the best seller.

Example:

Name - Sale

Rodrigo - 10.000,00

Bruno - 3.000,00

Lucas - 5.000,00

I wanna show the Rodrigo's sales in a Text Object.

Thanks

1 Solution

Accepted Solutions
prasad_dumbre
Partner - Creator
Partner - Creator

Hi,

The first expression given by Mr. Ramasamy ie." = FirstSortedValue(Name,  Aggr(-Sum(Sales),Name))"

seems working fine for what you explained . . .

View solution in original post

7 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try this expression.

     =only({<Sale = {'$(=Max(Sale))'}>} Name) &' - '& max(Sale)

Regards,

Kaushik Solanki    

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Nothing,

Thanks

MayilVahanan

Hi

Please try like this

= FirstSortedValue(Name,-Sum(Sales))

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
MayilVahanan

Hi

Please try like this

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

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Tell us what output you expect.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
prasad_dumbre
Partner - Creator
Partner - Creator

Hi,

The first expression given by Mr. Ramasamy ie." = FirstSortedValue(Name,  Aggr(-Sum(Sales),Name))"

seems working fine for what you explained . . .

Not applicable
Author

Perfect, thanks a lot!