Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting the overall rank regardless of other selection

I am using the expression below to get the rank of a field named "File_Name", but the results change whenever I select another field.  How can I get it to always display the same rank compared to all "File_Name"?

aggr(rank(count({<Status={'OT'},File_Name=>}Status)/Count({<File_Name=>}Status)),File_Name)

Any help would be appreciated.

2 Replies
Not applicable
Author

Can you post the file here so I can test off that?

Nicole-Smith

Adding a 1 in the set analysis should ignore all selections:

aggr(rank(count({1<Status={'OT'},File_Name=>}Status)/Count({1<File_Name=>}Status)),File_Name)