Discussion board where members can get started with QlikView.
I have dataset imported into QV similar to below:
Day Of Week
I'm trying to get QV to recognise this in my charts and 'order' them into a more human readable format.
Please see a picture of my problem http://imgur.com/Fr6cN
How can i reorder this to Mon, Tue, Wed, Thur, Fri, Sat, Sun.
I'm sure this is very simple, but your response would be most helpful.
Go to Solution.
Sort by numeric value will not work if your Day of Week field is imported as plain text from the source (instead of a numeric value with a text representation, a so called dual value).
But you can define a sort order in your script just like
LOAD * INLINE [
Take care that your day of week field name matches the one used in this INLINE load.
Then use DowSort as expression in sort by expression option in sort tab.
Hope this helps,
Go to sort tab and sort by Numeric Value acending, unselect Text.
thanks for your response, we're getting closer but I'm still getting some strange results.
Many thanks for your help. Nailed it!