Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a pivot table in my application ( Qliksense). now we have two columns in it
1- SalesMargin
2-Expense
Now i want my table to be first sorted by SalesMargin , but if the value of salesmargin is same in two entries it will be sorted according to my second column Expense.
Will this be possible ?
Thanks in advance
Gaurav
Have a look here: Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)
- Marcus
Its old topic, my recently needed to solve the same issue. Proposed answer here, solves different issue (different sorting on each dimensionality). The right answer here is as below:
ValueColumnA * max(ValueColumnB)*10
+ ValueColumnB
+ ValueColumnC * min(ValueColumnB)/10
That way it will sort with columns A, B, C. Asc/desc can be accomplished by replacing plus "+" with minus "-"