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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ordering Pivot Table

Hi,

I have a pivot table with two expressions.  One being a Percentage Rate and the other being the Denominator of the Rate (to give some context)

Pivot Table :

   

ConsultantWithin 7 DaysTotal Units
Employee 1100%1
Employee 249%432
Employee 344%157
Employee 443%175
Employee 532%205
Employee 629%69
Employee 725%142
Employee 824%133
Employee 924%228
Employee 1023%166
Employee 1123%229
Employee 1220%51
Employee 1319%37
Employee 1418%45
Employee 1518%34
Employee 1617%213
Employee 1717%190
Employee 1817%54
Employee 1917%24
Employee 2016%88
Employee 2116%273
Employee 2216%193
Employee 2316%206
Employee 2415%115
Employee 2515%227
Employee 2614%203

At the moment I am sorting on Rate in descending order.  However, this gives a false impression of the performance of the employees as Employee1 has only 1 Unit.  Is there a way in qlikview to order the Rate taking into account the number of units to give a more true representation?

Many thanks

2 Replies
gautik92
Specialist III
Specialist III

use rank function

Not applicable
Author

hi thanks for your reply,

Do you have an example please?