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

Rank Function

please suggest how to use rank function in my variable :

vError:


sum(aggr(fabs(sum([Absolute Error])),[Product Code],[Fiscal Month],[Fiscal Year],Measure,[Division Product Manager Code]))

4 Replies
Not applicable

Can you please explain the problem? I mean what exactly do you want to rank? Do you want to rank the sum of Absolute Numbers aggregated by multiple dimensions (mentioned in the code above)?

suvechha_b
Creator III
Creator III
Author

As I described above, I have an variable name vError which I am using in my expression but its not working according to the slider which I used.

For that I need to use the Rank function to work my slider.

the [Absolute Error] is not calculating according to the selection of slider.

Not applicable

Can you please share a sample application? It will be easier that way.

suvechha_b
Creator III
Creator III
Author

As I described above, I have an variable name vError which I am using in my expression but its not working according to the slider which I used.

For that I need to use the Rank function to work my slider.

the [Absolute Error] is not calculating according to the selection of slider.