Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sort by two expressions in Pivot?


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.