Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

jduenyas
Contributor III

User Sort on multiple fields

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: User Sort on multiple fields

"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

View solution in original post

4 Replies
vvira1316
Valued Contributor II

Re: User Sort on multiple fields

Hi,

you should be able to do it on Sort tab

Sort2.png

MVP & Luminary
MVP & Luminary

Re: User Sort on multiple fields

"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

View solution in original post

jduenyas
Contributor III

Re: User Sort on multiple fields

Thank you Rob.

What would we do without your knowledge.

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

Thanks

MVP & Luminary
MVP & Luminary

Re: User Sort on multiple fields

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