topic Re: Sort first by Field1 and then by Field2 in QlikView

Sort first by Field1 and then by Field2

maxsheva — Mon, 03 Apr 2017 10:23:55 GMT

Hi,

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

Name, DateEntering, DateGraduation

Name3, 01/01/2010, 01/01/2017

Name1, 01/02/2010, 01/14/2017

Name2, 01/02/2010, 01/15/2017

Forgot to add that I need make it in an object properties.

Thx.

Re: Sort first by Field1 and then by Field2

Anonymous — Mon, 03 Apr 2017 10:41:59 GMT

Max, You want it in a script or an object??

Re: Sort first by Field1 and then by Field2

MK_QSL — Mon, 03 Apr 2017 10:44:23 GMT

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

Data:

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

];

Noconcatenate

New:

Load Name, DateEnterig, DateGraduation Resident Data Order By DateEntering, DateGraduation;

Drop Table Data;

Re: Sort first by Field1 and then by Field2

sunny_talwar — Mon, 03 Apr 2017 10:59:41 GMT

Which object is this? Pivot table or straight table?

Re: Sort first by Field1 and then by Field2

maxsheva — Mon, 03 Apr 2017 11:41:08 GMT

I need for straight and for combo chart x values.

Re: Sort first by Field1 and then by Field2

Anonymous — Mon, 03 Apr 2017 11:46:25 GMT

Max, You can go to the sort tab and set the priorities of the dimensions in the order you needed.

Re: Sort first by Field1 and then by Field2

rahulpawarb — Mon, 03 Apr 2017 11:47:21 GMT

Hello Max,

Please refer attached sample application.

Regards!

Rahul

Re: Sort first by Field1 and then by Field2

maxsheva — Mon, 03 Apr 2017 16:21:00 GMT

Thank you.

Do you know how to do sort by two expressions in chart on x-Axis ?

Re: Sort first by Field1 and then by Field2

rahulpawarb — Wed, 05 Apr 2017 04:08:35 GMT

Hello Max,

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.

Regards!

Rahul

Re: Sort first by Field1 and then by Field2

maxsheva — Wed, 05 Apr 2017 19:50:53 GMT

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.

Thx.

Re: Sort first by Field1 and then by Field2

sunny_talwar — Wed, 05 Apr 2017 19:54:39 GMT

Try this:

DateEntering + DateGraduation/1E10

Re: Sort first by Field1 and then by Field2

maxsheva — Wed, 05 Apr 2017 20:05:28 GMT

Thank you Sunny, your solution is worked as usual.

Would you please explain why should we divide on this value '1E10'?

Sorting also is working without that.

Re: Sort first by Field1 and then by Field2

sunny_talwar — Wed, 05 Apr 2017 20:58:08 GMT

It is just giving a slight lower weight to the dategraduation. Adding 1e10 will be advisable because there might be a scenario where it might cause issues....top of my head, I can't come up with a scenario, but if you need I can come back and provide one where it might not work....

Re: Sort first by Field1 and then by Field2

maxsheva — Wed, 05 Apr 2017 21:30:52 GMT

OK, got it thx.

And one more question pls.

If I need sorting by more than one field I just use '+' sign and add expression.

For second and other fields I add lower weight by using '1E10'
Am I right?

Re: Sort first by Field1 and then by Field2

sunny_talwar — Thu, 06 Apr 2017 09:10:24 GMT

Yes, but if those are lower weighted then DateGraduation, I would divide by 1E11. The max you can can use is 1E14...so you can start accordingly. For example

Field1 + Field2/IE8 + Field3/1E10 + Field4/1E12 + Field5/1E14