topic Re: How to sort based on two columns? in QlikView

How to sort based on two columns?

Thu, 14 Jul 2016 11:56:25 GMT

How to sort based on two columns?

1 priority is the first column, than 2 priority is the second column????

sunny_talwar — Thu, 14 Jul 2016 12:05:36 GMT

Is this numeric sorting or text??? Would you be able to share a sample?

Thu, 14 Jul 2016 12:12:25 GMT

First I need to order by date, and then in each day sort by its numeric value . All Sortings are descending:

example:

This data:

14/7 -40

13/7 -30

13/7 -20

13/7 -25

12/7 -100

should be sorted to:

14/7 -40

13/7 -20

13/7 -25

13/7 -30

12/7 -100

sunny_talwar — Thu, 14 Jul 2016 12:23:29 GMT

How about something like this as your sort order expression:

Date*100000 - NumericValue