Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
peterderrington
Creator II
Creator II

Change order of expresion

Hi,

An easy question i'm sure......

I have a couple of (line) charts that have either the day of the week or the month as the second expression but they're showing in the wrong order (ie not chronologically).

I know that i have to add something into the expression box in the sort page but i'm not sure what.

Any ideas?

Thanks

Chart.jpg

1 Solution

Accepted Solutions
sunny_talwar

May be use a sort expression for your Day field:

Match(Day, 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday')

View solution in original post

3 Replies
sunny_talwar

May be use a sort expression for your Day field:

Match(Day, 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday')

View solution in original post

peterderrington
Creator II
Creator II
Author

Thank you so much,

i knew it had to be fairly simple.

And using your logic i used

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

and that organised my monthly ones too!

Thanks.

sunny_talwar

Month can be simplified using this as the sort expression:

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

Just need to make sure that you have this in your environmental variables:

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';