Sorting problem

[venkey2847]

Hi all,

I have a table with fields ID and Emprange

H.  No	Emprange
1	0 Employees
2	1-10 Employees
3	101-500 Employees
4	501-1,000 Employees
5	11-100 Employees
6	1,001-5,000 Employees

I reloaded and I have taken  Emprange as a filter.

It is not giving an order.

I need to have like below

Emprange

0 Employees

1-10 Employees

11-100 Employees

101-500 Employees

501-1,000 Employees

1,001-5000 Employees

My filter should be like above.

I got it by using Match function and now it is giving like that but if I make a selection it is not giving an order.

Suppose if I select 11-100 Employees, it turns into green colour and it arrives at top like below

Emprange

11-100 Employees

0 Employees

1-10 Employees

1001-5,000 Employees

501-1,000 Employees

100-500 Employees

It is giving like above.

But it should be as it is while selecting filter.

I need like below

Emprange

0 Employees

1-10 Employees

11-100 Employees

101-500 Employees

501-1,000 Employees

1,001-5,000 Employees

How can we achieve???

Please help me out this issue.

Thanks venkey.

[sunny_talwar]

What is your Match statement? Something like this?

Match(Emprange, .....)?

Try like this instead:

Match(Only({1} Emprange, ....)

[marcus_sommer]

I would create a new field from them like:

dual(Emprange, [H. No]) as Emprange

and then using a numeric sort-order within the sort-tab and also disabling the sorting to the selection state.

- Marcus

[maxgro]

Load the field Emprange before your data in the order you want,

then load all the other tables

and sort the listbox Emprange by load order original

[venkey2847]

@sunny,i used only({1} Emprange)

It works fine now but can you please explain me how it works briefly

Thanks alot

[sunny_talwar]

Without adding {1} you un-selected portion of Enprange becomes null which cannot be used within the Match function. When you add {1}, you ignore all selections and Enprange is always the same value. All I am doing is to ignore selections in your sort expression

Does this make sense?