Sorting the month by Month

[#1]

Hi,

I have a variable call Month and using

Apr, aug, Sep....as expression

but when I use bar chart to visual it

it sorting using Alphabetical order , as the attachment.

And try to explore the 'sorting' area. Seem no way to make it work.

Also attched the qvf file, in the 2nd app.

Thank you for any suggestions

[rohitk1609]

Hi Celine,

Add this =date(date#(month,'MMM'),'MMM') at your scripting part or where you are using month, it will sort w.r.t month. Same I did in your attach application.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Rohit Kumar

[sunny_talwar]

Or make use of Month function in the outer function instead of date

=Month(Date#(month,'MMM'))

[#4]

Hi, Rohit, hi Sunny,

Thank you so much.

and the same thing if I want to sort the 'date of the week'

Mon, Tue, Wen, Thu, Fri

How could I use this?

=date(date#(date,'MMM'),'MMM')  (guessing)

And where could I learn more regarding this

Scripting sorting in general? 

Regards,

Celine

[sunny_talwar]

I would suggest you to create day in the script like this and the sorting will be automatically taken care of

WeekDay(DateField) as WeekDay