topic Re: Retrive field value with aggr in QlikView

Retrive field value with aggr

ilanbaruch — Wed, 21 Oct 2015 13:37:45 GMT

Hi All,

i want to retrieve best Sales-Rep of the month into a text object,

i calculated value with:

aggr(sum(amount),Rep_Name) )

but i neet the name....

any ideas?

sunny_talwar — Wed, 21 Oct 2015 13:40:00 GMT

Try this:

=FirstSortedValue(Rep_Name, -Aggr(Sum(Amount), Rep_Name))

ilanbaruch — Wed, 21 Oct 2015 14:10:10 GMT

thank you!

I'll try my luck with another one:)

if I want to retrieve the best rep from specific dimension(department)?

sunny_talwar — Wed, 21 Oct 2015 14:12:38 GMT

Use the same expression in a straight table with department as your dimension.

ilanbaruch — Wed, 21 Oct 2015 14:16:51 GMT

is it possible in a text object?

sunny_talwar — Wed, 21 Oct 2015 14:18:53 GMT

You can use Concat function may be:

=Concat(Aggr(FirstSortedValue(Rep_Name, -Aggr(Sum(Amount), Rep_Name)), Department), ', ')

=Concat(Aggr(FirstSortedValue(Rep_Name, -Aggr(Sum(Amount), Rep_Name)), Department), Chr(10))