Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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 :
| Consultant | Within 7 Days | Total Units | 
| Employee 1 | 100% | 1 | 
| Employee 2 | 49% | 432 | 
| Employee 3 | 44% | 157 | 
| Employee 4 | 43% | 175 | 
| Employee 5 | 32% | 205 | 
| Employee 6 | 29% | 69 | 
| Employee 7 | 25% | 142 | 
| Employee 8 | 24% | 133 | 
| Employee 9 | 24% | 228 | 
| Employee 10 | 23% | 166 | 
| Employee 11 | 23% | 229 | 
| Employee 12 | 20% | 51 | 
| Employee 13 | 19% | 37 | 
| Employee 14 | 18% | 45 | 
| Employee 15 | 18% | 34 | 
| Employee 16 | 17% | 213 | 
| Employee 17 | 17% | 190 | 
| Employee 18 | 17% | 54 | 
| Employee 19 | 17% | 24 | 
| Employee 20 | 16% | 88 | 
| Employee 21 | 16% | 273 | 
| Employee 22 | 16% | 193 | 
| Employee 23 | 16% | 206 | 
| Employee 24 | 15% | 115 | 
| Employee 25 | 15% | 227 | 
| Employee 26 | 14% | 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
 
					
				
		
 gautik92
		
			gautik92
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		use rank function
 
					
				
		
hi thanks for your reply,
Do you have an example please?
