Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
omid5ive
Creator II
Creator II

show first rank

hi

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

1 Solution

Accepted Solutions
Kushal_Chawda

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

View solution in original post

7 Replies
susovan
Partner
Partner

Hi omid,

Try this expression,

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

Warm Regards,
Susovan
vikasmahajan

rank(sum(Sales))

vikasmahajan

Dimension = Month

Expressions

FirstSortedValue(Product, -Quantity)

FirstSortedValue(Quantity, -Quantity)

  

omid5ive
Creator II
Creator II
Author

i used this:

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

but it doesnt show any thing

Kushal_Chawda

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

View solution in original post

omid5ive
Creator II
Creator II
Author

Tanks Kushal

Kushal_Chawda

Welcome