Where you want to sort?
Are you looking to create new field based on sorting these in Back end (script) ?
If yes, provide some more information.
You can do something like
LOAD * INLINE [
Name, DateEntering, DateGraduation
Name1, 01/02/2010, 01/14/2017
Name2, 01/02/2010, 01/15/2017
Name3, 01/01/2010, 01/01/2017
Load Name, DateEnterig, DateGraduation Resident Data Order By DateEntering, DateGraduation;
Drop Table Data;
I have one question, out of two expression which one will take precedence while performing sorting. Could you please give us the sample sort order required?
BTW, On Sort Tab of object properties window, you can make use of Sort By Expression feature. Please refer attached sample expression.
Please correct me if I misunderstood.
SortDemo.qvw 154.0 K
Please, look at the attachment qvw file.
You may see Bar Chart where sort is by 'DateEntering' field.
This sort is not quite that I need. Sort order in Chart should be like in Table Box.
First by 'DateEntering' field and second by 'DateGraduation' field.
test.qvw 154.8 K