topic Re: Ordering my chart by DOW in QlikView

Ordering my chart by DOW

Thu, 11 Oct 2012 08:49:27 GMT

Hi,

I have dataset imported into QV similar to below:

Day Of Week

_____________

Mon

Tue

Thur

Mon

Sat

Sun

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.

Re: Ordering my chart by DOW

Thu, 11 Oct 2012 08:55:08 GMT

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

Regards

Rahul

Re: Ordering my chart by DOW

Thu, 11 Oct 2012 08:57:27 GMT

Hi,

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

Re: Ordering my chart by DOW

swuehl — Thu, 11 Oct 2012 09:08:08 GMT

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

Re: Ordering my chart by DOW

Thu, 11 Oct 2012 09:10:52 GMT

Many thanks for your help. Nailed it!