Order simple table by a explicit list

[#1]

Hi,

I would like to order the columns by a fixed criteria (a list of values of a field) and I d'ont remember the comand I need to write it in sort-->sort by expression.

What is the command I need?

Thanks

[stephencredmond · Accepted solution]

Hi,

I would use Match or MixMatch:

Sort Expression:  =Match(MyField, 'First', 'Second', 'Third', 'Fourth', 'Fifth', 'Sixth', 'Seventh')

Regards,

Stephen

Stephen Redmond is author of QlikView for Developer's Cookbook

He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.

Follow me on Twitter: @stephencredmond