Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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
Partner - Champion III
Partner - Champion III

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.