Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Ordering my chart by DOW

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

4 Replies
Not applicable

Re: Ordering my chart by DOW

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

Regards

Rahul

Not applicable

Re: Ordering my chart by DOW

Hi,

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

ChartExample.png

MVP
MVP

Re: Ordering my chart by DOW

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

Re: Ordering my chart by DOW

Many thanks for your help. Nailed it!

Community Browser