Ordering my chart by DOW

[#1]

Hi,

I have dataset imported into QV similar to below:

Day Of Week

_____________

Mon

Tue

Thur

Mon

Sat

Sat

Sun

Mon

Mon

Wed

Thur

Fri

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.

KR
James.

[#2]

Go to sort tab and sort by Numeric Value acending, unselect Text.

Regards

Rahul

[#3]

Hi,

thanks for your response, we're getting closer but I'm still getting some strange results.

[swuehl · Accepted 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 [

Dow, DowSort

Mon,1

Tue,2

Wed,3

Thu,4

Fri,5

Sat,6

Sun,7

]

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,

Stefan

[#5]

Many thanks for your help. Nailed it!