Order simple table by a explicit list

Wed, 10 Jul 2013 17:54:51 GMT

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

Re: Order simple table by a explicit list

stephencredmond — Wed, 10 Jul 2013 19:36:15 GMT

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

topic Re: Order simple table by a explicit list in QlikView

Order simple table by a explicit list

Re: Order simple table by a explicit list