Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
asknyldz
Contributor III
Contributor III

Expression Sort

Hi there,

When i click to Apr, this is going to end. I want to stay stable. ould you please help me.

Error1.jpg

Error2.jpg

1 Solution

Accepted Solutions
ionut_toader
Partner - Contributor II
Partner - Contributor II

Hi Askin,

Why do you need to use expression sort?

Did you try to use just "Numeric Value"-> Ascending, with no other sorting options?

Kind regards,

Ionut

View solution in original post

5 Replies
Gysbert_Wassenaar

Try Match(Only({1}Month), ...etc)


talk is cheap, supply exceeds demand
asknyldz
Contributor III
Contributor III
Author

Hi Gysbert, thanks for answer but i don't understand, is it possible could you please write full expression as;

=Match([MONTH],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

Thank you

ionut_toader
Partner - Contributor II
Partner - Contributor II

Hi Askin,

Why do you need to use expression sort?

Did you try to use just "Numeric Value"-> Ascending, with no other sorting options?

Kind regards,

Ionut

asknyldz
Contributor III
Contributor III
Author

Dear Ionut,

That's worked.

Thanks.

krishna20
Specialist II
Specialist II

Hi,

Try this.

Enable, State ->AutoAscending  & Numeric -> Ascending.