Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Problem with sorting

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!

6 Replies
Highlighted
Not applicable

Problem with sorting

Hi,

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

Good luck!

Rainer

Highlighted
Not applicable

Problem with sorting

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

Highlighted
Not applicable

Problem with sorting

click on override Group Sort Order and sort by State

Highlighted
Not applicable

Problem with sorting

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

I can't seem to find it.

Highlighted
Not applicable

Problem with sorting

Properties, Sort.

Highlighted
Not applicable

Problem with sorting

can you upload a sample please?