topic sort sequence in QlikView

sort sequence

Wed, 21 Jul 2010 06:39:40 GMT

Hello All,

I have been through the forum and have found many useful ways of sorting especially the post about sorting within a group dimension. Even so I am struggling with the group I have created in the attached example. The group is multilevel and needs to be sorted as follows:

1> Quarter-Year , needs to be sorted logically by year-quarter

2> TPP - Sort order is HCD,ECD,DCD,SCD (always does not matter what numbers they show except if one is 0)

3> Month - Logical

4> Days of the month - Logical

I have spent several hours trying to test this to be correct. Any help appreciated. MAny thanks.

sort sequence

Wed, 21 Jul 2010 21:46:13 GMT

Each of the fields in the group have thier own sort behavior. If you edit your group, there is a 'sort order' button at the bottom of the window. You can define how each of your various group conditions will sort.

You also need to turn off 'override group sort' which you have selected in a number of your charts.

sort sequence

Thu, 22 Jul 2010 08:49:24 GMT

Thanks Ryan,

I have done so but I think I am struggling with sorting the Quarter field, everything else I have sorted out.

Thanks,

Kiran