topic Re: User Sort on multiple fields in QlikView

User Sort on multiple fields

jduenyas — Wed, 25 Nov 2020 16:16:04 GMT

Hello All

Excel allows a user to sort a table on multiple fields:

How can I duplicate this feature in QV, if at all possible.

(In a straight table, double clicking header of a column will sort up or down but once a second field is sorted the first one loses its order)

Thanks

Re: User Sort on multiple fields

vvira1316 — Thu, 28 Sep 2017 22:44:38 GMT

Hi,

you should be able to do it on Sort tab

Re: User Sort on multiple fields

rwunderlich — Thu, 28 Sep 2017 22:55:43 GMT

"once a second field is sorted the first one loses its order"

not actually correct. The last field sorted is the primary sort, The field sorted before that becomes the secondary sort and so on.

So if you sort by Amount.

And then by State.

The table is sorted by State, Amount.

-Rob

Re: User Sort on multiple fields

jduenyas — Fri, 29 Sep 2017 00:26:39 GMT

Thank you Rob.

What would we do without your knowledge.

I was able to confirm. It is as you stated.

Thanks

Re: User Sort on multiple fields

rwunderlich — Fri, 29 Sep 2017 03:44:14 GMT

I'll admit it's not obvious. It usually requires pointing out to users. I'm a big fan of doing a 30 minute training with new QV users to cover things like sorting, searching, exporting.

-Rob