show rank of each branch

[omid5ive]

hi

how can i show each branch rank in text box?

[Anonymous]

did you check this?

Rank Function | Qlik Community

[omid5ive]

i dont know how can i use it

for example i have list of branch with amount of their sales

i want to show the name of branch with maximum value of sales

i want another text box with second maximum sale and ...

[Anonymous]

Could you elaborate more, what exactly you want?

[qlikview979]

Hi this help fill to you

FirstSortedValue(Branch, sum(Sales),Brach)

or

FirstSortedValue(Branch, -sum(Sales))

with Aggregation:- FirstSortedValue(Branch, -aggr(sum(Sales),Brach))

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

Note:- Instead of 'Branch' and 'Sales' write your field names.

[Anonymous]

You want like this?

Top 5 analysis using Rank fuction

Replace ProductID with Branch..

or

check this as well

FirstSortedValue()

[omid5ive]

how can i show rank 3?

[omid5ive]

foe example i have this data:

Branch_Code	Sale
100	200
101	125
100	300
101	126
200	10
200	250

i want to have 3 label that the first one show branch 100

the second one show 200 and third one show 101

[omid5ive]

i want something like this:

=rank(sum({<Branch_Code={1}>}sales))

[qlikview979]

Hi   i hope this is help full to you

Please find the attached file.

rank(sum(Sale))