How to Sort Objects in Selection Area

[#1]

Hi ,

Please can i know how to sort the objects in Selection Area in Qlik Sense.

Ex : If i select a week from week object . In Selection Area Except selected week , how to sort week in descending order (it means latest week from top order in selection Area)

Please Let me know your thoughts

Thanks in Advance

Thanks

Varun Donthu

[Gysbert_Wassenaar]

Disable the Automatic sorting and choose Sort numerically, Descending

[#3]

Hi Gysbert Wassenaar,

Thanks a lot for your reply and suggestion .

I have tried it what u have suggested me but it didn't worked. Can you tel me any other options to sort in selection area .

Thanks

Varun Donthu

[Gysbert_Wassenaar]

but it didn't worked.

Can you explain what you expect to work in which way in more detail?

[JonnyPoole]

Often the date#() will help you gain sorting you want . Its versatile but depends on the data format

For example if your week data looks like the following  (format = YYYYWW):

201501

201502

then sort by expression:   date#([Weekfield],'YYYYWW') 

[#6]

Hi Gysbert Wassenaar,

Here is the below screen shot which am looking for sorting in selection area in descending order .

Please share your thoughts on the below thing.

[Gysbert_Wassenaar · Accepted solution]

I see what you mean. As far as I know there is no way to change the sorting there.

[#8]

Gysbert Wasssenaar ,

Thanks a lot for your help and suggestions. we also investigated for this solution but we didn't get it .

What you said is correct . We can't sort there.

Thanks a lot

Varun Donthu