9 Replies Latest reply: Nov 30, 2009 4:38 PM by Peter Rieper

# Sorting in Cyclic Groups within dimensions

Hi,

I have a problem with the sorting of cyclic groups within dimensions tab.

Problem:
I am not able to get the correct sorting Order for the cases, because I am using a cyclic group "Release Group" within the dimensions tab.
How can I get the sorting order in a correct form? Sorting numerically descending.
I hope somebody could help me! Please use the sample .qvw for solutions.
Thanks,
Kind regards,
Herbert

• ###### Sorting in Cyclic Groups within dimensions

Hi Herbert,

How would you like them sorted?

Alphabetically / Numerically?

Thanks

• ###### Sorting in Cyclic Groups within dimensions
Hi, Sorry I have forgotten to say this, I want it to sort it numerically in descending order. Regards, Herbert
• ###### Sorting in Cyclic Groups within dimensions

You should change the sorting to "Y"-value.

HTH
Peter

• ###### Sorting in Cyclic Groups within dimensions

I have tried it before, normally it works with sorting by "Y" - value, but not when I use cyclic groups and I must use this cyclic groups in my real application.

Please use my sample .qvw for trying to sort it correctly.

Thanks for helping me.

Regards,

Herbert

• ###### Sorting in Cyclic Groups within dimensions

"Case" is the first dimension in your table and the sorting can follow only the first dimension

Peter

• ###### Sorting in Cyclic Groups within dimensions

Hi,

Yes, and I also want to sort the field case but numerically, so the case with the highest sum should be Case Three 2893, second ==> Case Two 2627 and so on.

I think I must use the formular sorting but I don't know which formular I should use.

Regards,

Herbert

• ###### Sorting in Cyclic Groups within dimensions

Think that the "problem" is the cyclic group, which is probably considered by QV as kind of calculated dimensions, for which espressively the sort-functionality does not work.
What if you would work with kind of variable and do the determination, which Release to be shown, in an expression?

Peter

• ###### Sorting in Cyclic Groups within dimensions

I think Peter you are right, I can see no possibility to sort it in comparison to which field of the cyclic group is currently used.

To your sugestion, have you got an example .qvw for me in which I can get a solution for my problem with the help of variables, I don't know how I can realize this.