Sorting Issues

[akpofureenughwu]

Good morning everyone,

I have been having issue sorting lately...

I used the script:

Match ([Repair.Month], 'January','February','March','April','May','June','July','August','September','October','November','December')

But stilll the data is not sorted by month,,,,

Please kindly help me review it.

Regards

See attached

[akpofureenughwu]

Hello..... Rahul are you there?

It's a sql query generated data.

[rahulpawarb]

Hello Akpofure,

Sorry I was away for while. BTW, you can share the application file.

Regards!

Rahul

[akpofureenughwu]

Here is a sample

[MarcoWedel]

Hi,

one solution might be

Dual(Month, Month(Date#(Month,'MMMM'))) as Month

hope this helps

regards

Marco

[rahulpawarb]

Hello Akpofure,

I agree with Marco. You try the suggested approach. BTW, you can change the sort order under Sorting tab of Table object (New Sort Order - Unit, Year, Month).

Hope this will be helpful.

Regards!

Rahul

[MarcoWedel]

Please close your thread if your question is answered.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks

Regards

Marco