topic Re: How can i get a single row in QlikView

[Solved]How can i get a single row

Wed, 03 Apr 2013 18:33:06 GMT

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

kaushiknsolanki — Wed, 03 Apr 2013 18:38:10 GMT

Hi,

Try this expression.

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

Regards,

Kaushik Solanki

Wed, 03 Apr 2013 18:51:59 GMT

Nothing,

Thanks

MayilVahanan — Wed, 03 Apr 2013 22:38:13 GMT

Please try like this

= FirstSortedValue(Name,-Sum(Sales))

Hope it helps

MayilVahanan — Wed, 03 Apr 2013 22:39:13 GMT

Please try like this

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

Hope it helps

kaushiknsolanki — Thu, 04 Apr 2013 05:26:24 GMT

Hi,

Tell us what output you expect.

Regards,

Kaushik Solanki

prasad_dumbre — Thu, 04 Apr 2013 07:12:54 GMT

Hi,

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

seems working fine for what you explained . . .

Thu, 04 Apr 2013 11:20:17 GMT

Perfect, thanks a lot!