Solved: Re: show first rank - Qlik Community

omid5ive · ‎2016-06-16

hi

how can i show the branch with highest sale in label?

Kushal_Chawda · ‎2016-06-16

=FirstSortedValue(Branch, -aggr(sum(Sales),Brach))

View solution in original post

susovan · ‎2016-06-16

Hi omid,

Try this expression,

Num(Aggr(Rank(Sum({1} "Measure"),4),"Dimension"))

Warm Regards,
Susovan

vikasmahajan · ‎2016-06-16

rank(sum(Sales))

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2016-06-16

Dimension = Month

Expressions

FirstSortedValue(Product, -Quantity)

FirstSortedValue(Quantity, -Quantity)

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

omid5ive · ‎2016-06-16

i used this:

=num(Aggr(Rank(Sum({1} L_COUNT),4),PROVIENCE_NAME))

but it doesnt show any thing

Kushal_Chawda · ‎2016-06-16

=FirstSortedValue(Branch, -aggr(sum(Sales),Brach))

omid5ive · ‎2016-06-16

Tanks Kushal

Kushal_Chawda · ‎2016-06-16

Welcome