Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Creator II
Creator II

Sorting a table

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

1 Reply
Or
Master III
Master III

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.