Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Order simple table by a explicit list

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

1 Solution

Accepted Solutions
stephencredmond
Luminary Alumni
Luminary Alumni

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

View solution in original post

1 Reply
stephencredmond
Luminary Alumni
Luminary Alumni

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