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

Please help me out in Rank Function.

How to put Rank function in the below expression.

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

Note : vError is a variable , calculating the below expression,

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

$(vRankNo) is the variable defining number 25.

I have already given my model in the below link: name example.qvw

http://community.qlik.com/message/411018#411018

0 Replies