Sorting a table

[TomBond77]

Hi experts

We have a given table outside of Qlik. 

We loaded the raw data and need to "sort" the table as the external table is.

Can you sort in Qlik individually by dimension value a table?

Example

Group:

Sales

Costs

Margin.

Sales must be at first rank, thereafter costs and finally Margin.

Thank you

Tom

[Or]

Create your own sorting table, e.g.

Load * INLINE [

Group, Order

Sales, 10

Costs, 20

Margin, 30];

Then you can either sort by order, or if you prefer, you can create a field Dual(Group, Order) which will auto-sort numerically.