topic Re: rank() question in QlikView

rank() question

Mon, 18 Jun 2012 07:18:16 GMT

i have table like this.

i used rank(score) to get top 10, but when the score are the same, i want to sort by <# of surveys> by dec, i do not know how to achieve it

for example:

Derick /Herica /Agnes all got 4.92, but i want to sort their rank by # of surveys

Rank	Center	Teacher Name	score	# of surveys
1	J	jack	4.95	15
2	S	Derick	4.92	20
3	C	Herica	4.92	17
4	J	Agnes	4.92	26
5	S	Roneill	4.91	19
6	J	Lydia	4.90	21
7	S	Simone	4.87	20
8-9	C	Brian	4.85	15
8-9	JH	James	4.85	15
10	S	Esme	4.84	16

Mon, 18 Jun 2012 07:47:47 GMT

Hi,

I think, in SORT tab (of the properties of your chart), you can first sort it by rank and then by score.

Regards,

christophebrault — Mon, 18 Jun 2012 08:43:00 GMT

Hi,

If you want that your rank column be true, try this :

=rank(sum(score)+sum(# of surveys)/10000)

Turn surveys to decimal and add to score in the rank function.

Mon, 18 Jun 2012 09:18:43 GMT

above both not working

center name and teacher name is dimenion and scores and # of seuveys is expression in straight table

Mon, 18 Jun 2012 09:18:50 GMT

above both not working

center name and teacher name is dimenion and scores and # of seuveys is expression in straight table

Mon, 18 Jun 2012 09:19:02 GMT

above both not working

center name and teacher name is dimenion and scores and # of seuveys is expression in straight table

above both not working

center name and teacher name is dimenion and scores and # of seuveys is expression in straight table

Anonymous — Mon, 18 Jun 2012 09:52:30 GMT

hi maxshen

Try the following

Go to sort tab

for Rank field - check d box numeric feild- ascending

then

for # surveys field - check d box numeric filed -descending

you can simply take table box n do the above.

please try n let me knw.

reagards,

vaibhav.