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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Rank Function

I have attached my example model...

I want to apply rank function to calculated Error and Accuracy Column according to Slider.

Note:Error is calculated on a variable name vAbsError

and Accuracy in vAbsAccuracy.

4 Replies
Clever_Anjos
Employee
Employee

=rank($(vAbsError)) and rank($(vAbsAccuracy))does not return what you want?

suvechha_b
Creator III
Creator III
Author

No it is not working...

Please check my example model....

suvechha_b
Creator III
Creator III
Author

Can you please suggest how to apply rank function in tmy below expression:

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

Clever_Anjos
Employee
Employee

Well,

Maybe I´m missing something.

It seems working to me

Capturar.PNG.png