topic Re: Expression Sort in QlikView

Expression Sort

asknyldz — Thu, 15 Oct 2015 11:24:10 GMT

Hi there,

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

Gysbert_Wassenaar — Thu, 15 Oct 2015 11:49:46 GMT

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

asknyldz — Thu, 15 Oct 2015 12:00:57 GMT

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 — Thu, 15 Oct 2015 12:02:15 GMT

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 — Thu, 15 Oct 2015 13:30:32 GMT

Dear Ionut,

That's worked.

Thanks.

krishna20 — Thu, 15 Oct 2015 13:32:58 GMT

Hi,

Try this.

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