I have a chart where the x axis is weekdays, and I want to put it in order ie. Mon. Tues. Wed. Right now I only know how to sort by alphabetical (A->Z), or y axis. Is there an expression that will let me change it so it is chronological?
I'm not able to open Chandashok's qvw on my iPad so I don't know if this solution's already been presented...
To expand on Dennis's suggestion, one way to sort string values in a desired order is to preload the order in the script. QlikView stores each field in its own memory table and distinct values are concenated as they are loaded. In this example, you should load the day of the week in an inlne table at the top of your script then drop it at the end. Something like:
LOAD * INLINE [
DROP TABLE Weekdays;
Now, in your chart on the sort tab, promote Weekday to the top and check the box to sort by Load Order.
NOTE: The field name "Weekday" in the inline table must be EXACTLY the same as the field name from the main data load.