This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
How can I make sort first by Field1 and then by Field2?
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
I need first sort by DateEntering and then by DateGraduation.
As a result next
Forgot to add that I need make it in an object properties.
DateEntering + DateGraduation/1E10
View solution in original post
Max, You want it in a script or an object??
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 Name, DateEnterig, DateGraduation Resident Data Order By DateEntering, DateGraduation;
Drop Table Data;
Which object is this? Pivot table or straight table?
I need for straight and for combo chart x values.
Max, You can go to the sort tab and set the priorities of the dimensions in the order you needed.
Please refer attached sample application.
Do you know how to do sort by two expressions in chart on x-Axis ?
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.
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.