This content has been marked as final. Show 4 replies
We are using Qlik Sense April 2018 version.
We have a business requirement on rank function.In my qvd i have Emp Name,Sales Value and Revenue value.I want calculate the Rank of Employee first based on Sales Value and then on Revenue .If the Sales value of two employees are same then it should check for revenue value and then calculate the final rank for the employee.
Please find the below example.
|CC||Sales||Revenue||Rank(sum(Sales))||Rank(sum(Revenue))||Final Rank(If sales rank is same then check for revenue rank)|
Please help me to resolve this issue.