Discussion board where members can get started with QlikView.
I need to sort the data on Date
I have Date field with to Two Dates
1 - 12/31/2014
2 - 01/01/2015
Now its looking like
I want it to be 12/31/2015 first and 01/01/2015 in order
I have removed other sorting options on other Dim and Expr
Move the date field to the top of the sort priority list on the Sort tab.
And check that your dates are real dates and not text values. Try adding the date field to a list box and changing the Number format to one of the number formats.
If your date values are text values the use the date#() function in the script to create real date values: date#(MyDate,'MM/DD/YYYY') as MyDate.
View solution in original post
If these are proper QV dates, you can just sort them numerically. Go to the sort tab and ensure that the numeric option is ticked.
If they are strings, I recommend that you convert them to date during the load - something like
Date(Date#(Date), 'MM/DD/YYYY')) As Date,