topic Re: Sorting Date output in correct order in QlikView

Sorting Date output in correct order

Tue, 12 Feb 2013 11:38:39 GMT

Hello, I am trying to sort the presentation of a date in the correct order which im struggling with.

I am using the code :- month(Posting_Date)&' '&chr(39)&right(Posting_Date,2) as Posting_Month so that if there is a date of 12/07/2011 it will be presented as Jul '11.

I have under the presentation tab hit Dropdown select and all the months are in a random order and i've no idea how to sort them into correct order.

Any ideas?

Paul.

Re: Sorting Date output in correct order

vivientexier — Tue, 12 Feb 2013 11:44:37 GMT

In your script, create a field like this :

LOAD

,...

,Posting_Date*1 as Posting_Date_num

FROM ...

Then, in your object, ask QlikView to sort ("sort" tab) by expression. This expression will be "Posting_Date_num".

Re: Sorting Date output in correct order

Tue, 12 Feb 2013 11:53:44 GMT

Sorry I sent email prematurely

I am getting

Jan ‘12

Feb’ 12

Etc.

It seems that a month is being presented in the drop down multiple times one for each record.

Paul.

Re: Sorting Date output in correct order

swuehl — Tue, 12 Feb 2013 12:00:40 GMT

Use something like

date( monthstart(Posting_Date),'MMM YY')

Re: Sorting Date output in correct order

Tue, 12 Feb 2013 12:16:44 GMT

Swuehl, you're a star, thank you!

Paul.