Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
omid5ive
Creator II
Creator II

ranking

hi

i need to have some label that when i click on each branch id, it shows the rank of the sale

for example my data like this:

Branch_IDSale
1001250
1011452
1031301

when i click on 101 my lable should show 1 and when i click on 100 it should show 3

what should i do?

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

May be this,

='Rank ' & Num(Aggr(Rank(Sum({1} Sale),4),Branch_ID))

View solution in original post

3 Replies
tamilarasu
Champion
Champion

May be this,

='Rank ' & Num(Aggr(Rank(Sum({1} Sale),4),Branch_ID))

muthukumar77
Partner - Creator III
Partner - Creator III

Hi,

I hope it will helpful for you.

Muthukumar Pandiyan
MayilVahanan

Try like this

Aggr(Rank(Sum({<Branch_ID=>} Sale)),Branch_ID)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.