Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
omid5ive
Creator II
Creator II

rank

i want something like this:

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



what should i do?

14 Replies
Kushal_Chawda

what set analysis condition you are trying to put?

omid5ive
Creator II
Creator II
Author

aggr.PNG

it shows this

sunny_talwar

My bad, try this:

Only({<Branch_Code = {1}>} Aggr(Rank(Sum(Sales)), Branch_Code))

Only({<Branch_Code = {2}>} Aggr(Rank(Sum(Sales)), Branch_Code))

Only({<Branch_Code = {3}>} Aggr(Rank(Sum(Sales)), Branch_Code))

omid5ive
Creator II
Creator II
Author

branch_code=1 or some other values

i want to have multi text box that contains the rank of each branch

omid5ive
Creator II
Creator II
Author

Thank you Sunny