Qlik Sort Order

[wonkymeister]

Hi,

i need to sort a dimension - based on its values - twice. Is it possible?

i want to sort by:

value name in dimension = Department, and then A-Z

so:

Department

Alex

Brian

Claire

Dennis

Harold

etc...

Department has to come first, and everything else must be A-Z

any ideas guys?

Qlik 11.2, SR12

[sunny_talwar · Accepted solution]

May be like Sort by expression and then text

Expression sort using this

Match(Dimension, 'Department', Dimension)

Text sort

A -> Z

[wonkymeister]

brilliant, cheers!