Sorting based on two column values

[#1]

I would like to sort the pivot table based on two column values

Like consider i will sorting by Number and Alphabet. those Columns will not be part of Dimension or expression.

Is there any way we use combine two columns and sort it ...

[hic]

You can create an expression to describe the sort order and use this in the chart properties->sort->sort by expression, e.g

   Number*100 + ord(Alphabet)

Multiplying by 100 will make the sort by Number first then by Alphabet.

HIC

[IAMDV]

Very useful to know. Thank you very much HIC.

Cheers,

DV

www.QlikShare.com