topic Sort sequence when sorting by expression in QlikView

Sort sequence when sorting by expression

Wed, 24 Aug 2011 14:50:58 GMT

When sorting codes HC, PD, SO, WD, WO, XO alphabetically they come out in proper sequence. However, when sorting the associated description using the codes in a "sort by expression", the resulting sequence is HC, PD, WD, SO, WO, XO.

It appears to me that the sort is using the last character as the primary sort (hence C(H), D(P), D(W), O(S), O(W), O(X)...

Should I be raising this as a bug? Or have I missed a setting somewhere?

Bob

Sort sequence when sorting by expression

Wed, 24 Aug 2011 14:57:49 GMT

Sort by expression looks at the numeric evaluation of the expression.

You could use the match function.

For example: match(fieldname,'HC','PD','WD','SO','WO','XO')

Regards,

Bert

Re: Sort sequence when sorting by expression

Wed, 24 Aug 2011 15:51:47 GMT

Thanks, Bert.

That works. It does mean hardcoding the values into the expression, though, which is something I was trying to avoid..

Bob