RANK TABLE

[eva_maria]

Hi!

From the table that i put in my question file, i need to create tables like that, where numbers are the ranking depending on the average value. If the average is the same, the rank will be the same.

Thanks for your help.

table 1 only with pto
pto	Q1_E	Q2_E	Q3_E	Q4_E	Q1_J	Q2_J	Q3_J	Q4_J
COM	1	2	1	1	3	2	1	2
DIR	2	3	2	1	2	3	1	2
JCDTOS	1	1	2	3	2	1	3	4
SUBD	2	2	1	3	2	2	1	2
table 2 with pto and zone
pto_zon	Q1_E	Q2_E	Q3_E	Q4_E	Q1_J	Q2_J	Q3_J	Q4_J
COM_G	1	2	1	1	1	2	1	2
COM_S	1	1	1	1	2	1	1	1
DIR_G	2	2	1	1	2	3	1	2
DIR_M	1	1	1	1	2	2	1	2
DIR_S	2	3	4	1	1	1	1	1

[Frank_Hartmann]

Did you manage it?

[eva_maria]

Yes, something goes wrong with my qlikview, just changing hrank for rank and then again, just works fine.

Thanks!!