topic Problem with sorting in QlikView

Problem with sorting

Thu, 15 Jul 2010 13:26:36 GMT

Hi guys,

I've checked previous posts about similar problems, but nothing seems to work.

It is about sorting months. I have tried something from the forum: index('Mar;Apr;May;Jun',subfield(filename(),' ',2)) as MonthNum, but this doesn't sort my four months when I sort them by exression MonthNum.

We have also tried:

LOAD *
inline [Month, SortMonth
Mar,3
Apr,4
May,5
Jun,6
];

which generally sorts the months, but the selected field always moves to the top of my listbox. Also if I check "Always one selected value" (which should be the case with my report), the sorting goes to waste.

If you can give me an idea why this happens, it would be great!

Thank you!

Problem with sorting

Thu, 15 Jul 2010 13:29:53 GMT

Hi,

go to Listbox Properties => Sort and diable "Sort by STATE".

Good luck!

Rainer

Problem with sorting

Thu, 15 Jul 2010 13:39:52 GMT

Thanks, but sort by state (auto ascending, or any) is already disabled.

Problem with sorting

Thu, 15 Jul 2010 13:55:26 GMT

click on override Group Sort Order and sort by State

Problem with sorting

Thu, 15 Jul 2010 14:10:12 GMT

I'm sorry. Could you please tell me where I can click this "override Group sort order".

I can't seem to find it.

Problem with sorting

Thu, 15 Jul 2010 14:11:16 GMT

Properties, Sort.

Problem with sorting

Thu, 15 Jul 2010 14:12:40 GMT

can you upload a sample please?