topic Re: sorting based on multiple columns in QlikView

sorting based on multiple columns

Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I want to apply sort in the straight table based on more than one column

example first it should sort consignment number then shipment number and then order number in increasing order

Re: sorting based on multiple columns

krishnacbe — Wed, 26 Oct 2016 14:30:18 GMT

Hi,

Go to Sort Tab and set the priority order as you need.

Re: sorting based on multiple columns

sunny_talwar — Wed, 26 Oct 2016 14:31:18 GMT

You should be able to prioritize the sort dimension/expression on the sort tab

Re: sorting based on multiple columns

gajapathy74 — Wed, 26 Oct 2016 14:32:20 GMT

Go to the Sort tab and move around the columns based on the order you need using Promote / Demote and choose Sort by options from the right-hand side as you need.

Re: sorting based on multiple columns

rubenmarin — Wed, 26 Oct 2016 14:38:07 GMT

Hi Vibhu, and if you want to prevent users to change the sort uncheck the 'allow interactive sort' option (at the bottom-left of the Sort tab)

Re: sorting based on multiple columns

Wed, 26 Oct 2016 15:49:15 GMT

Hi,

will the sort remains same after applying filters?

Re: sorting based on multiple columns

krishnacbe — Wed, 26 Oct 2016 16:07:01 GMT

Yes, Sorting will remain same order after applying filters.