Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.