Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ordering my chart by DOW

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

4 Replies
Not applicable
Author

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

Regards

Rahul

Not applicable
Author

Hi,

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

ChartExample.png

swuehl
MVP
MVP

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

Not applicable
Author

Many thanks for your help. Nailed it!