Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sort by two expressions in Pivot?

Hi,

I have a pivot chart with a dozen or so columns in.  I want to sort the pivot by two of the columns, both of which are expressions.  No problem with the first one, I simply add the expression to the initial dimension column and it works.  But how do I then sort by the second column (expression) for those items with identical values on the first column (expression)?

I've tried adding it to the second dimension field, which seems to be ignored completely.  I've tried working on the expression to sort by expression 2 if expression 1 matches, but no luck.

Any ideas out there?  I'm using QV10 SR1.

Thanks

Nick

0 Replies