sort is not working in QV 10 of straight table

[#1]

sort is not working in QV 10 of straight table

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:

D /H /A all got 4.92, but i want to sort their rank by # of surveys

Rank	Center	Name	overall score	# of surveys
1	J	a	4.95	15
2	S	D	4.92	20
3	C	H	4.92	17
4	J	A	4.92	26
5	S	Ro	4.91	19
6	J	Ly	4.90	21
7	S	Si	4.87	20
8-9	C	Br	4.85	15
8-9	JH	Ja	4.85	15
10	S	Es	4.84	16

overall score(average(score) and # of surveys (count(suvery) is used in expressions of this straight table

# of surveys (count(suvery) is used as same with overallscore with Descending

[#2]

and i have a caculated dimension,which will affect the sorting?

[#3]

Hi,

Can u share your qvw?

Regards

Apurva

[sivarajs]

just promote #of surveys to first position then order by desc

[jonathandienst]

Hi

Are you sure that the overall scores for D/H/A were all exactly 4.92, or is the the displayed value a rounding to 2 decimals? It could be that the value of A is not exactly the same as D and H (eg 4.917 vs 4.92)

Regards

Jonathan

[#6]

Do you have any disabled expressions and then enabled expressions after them?  I have found when this happens sorting does not always work.  Move all of the disabled expressions to the bottom of the expression list.

Looks like this...

exp1 enabled

exp2 disabled

exp3 enabled

Change to...

exp1 enabled

exp3 enabled

exp2 disabled