Discussion board where members can get started with QlikView.
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.
Go to Solution.
Use something like
date( monthstart(Posting_Date),'MMM YY')
In your script, create a field like this :
,Posting_Date*1 as Posting_Date_num
Then, in your object, ask QlikView to sort ("sort" tab) by expression. This expression will be "Posting_Date_num".
Sorry I sent email prematurely
I am getting
It seems that a month is being presented in the drop down multiple times one for each record.
Swuehl, you're a star, thank you!