Ordering Pivot Table

Thu, 10 Sep 2015 09:32:46 GMT

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

Re: Ordering Pivot Table

gautik92 — Thu, 10 Sep 2015 09:35:59 GMT

use rank function

Re: Ordering Pivot Table

Thu, 10 Sep 2015 09:40:00 GMT

hi thanks for your reply,

Do you have an example please?

topic Re: Ordering Pivot Table in QlikView

Ordering Pivot Table

Re: Ordering Pivot Table

Re: Ordering Pivot Table