Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like Sort by expression and then text
Expression sort using this
Match(Dimension, 'Department', Dimension)
Text sort
A -> Z
May be like Sort by expression and then text
Expression sort using this
Match(Dimension, 'Department', Dimension)
Text sort
A -> Z
brilliant, cheers!