Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: How can i get a single row

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
Highlighted
MVP & Luminary
MVP & Luminary

Re: How can i get a single row

Hi,

     Try this expression.

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

Regards,

Kaushik Solanki    

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Not applicable

Re: How can i get a single row

Nothing,

Thanks

Highlighted

Re: How can i get a single row

Hi

Please try like this

= FirstSortedValue(Name,-Sum(Sales))

Hope it helps

Highlighted

Re: How can i get a single row

Hi

Please try like this

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

Hope it helps

Highlighted
MVP & Luminary
MVP & Luminary

Re: How can i get a single row

Hi,

     Tell us what output you expect.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Partner
Partner

Re: How can i get a single row

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

Highlighted
Not applicable

Re: How can i get a single row

Perfect, thanks a lot!