Discussion Board for collaboration related to QlikView App Development.
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.
May be use a sort expression for your Day field:
Match(Day, 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday')
View solution in original post
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!
Month can be simplified using this as the sort expression:
Just need to make sure that you have this in your environmental variables: