List box sorting

[agni_gold]

Hi Experts ,

Is this possible in listbox ,

if i have two different listboxs one is year and other is account , both fields are linked ,

but if i select year then account will not sort by year value .

[evan_kurowski]

Hello Agnivesh,

What you need is a dynamic sort expression in the Account listbox.

=IF(GetSelectedCount(Year)>0,Account, Max({1} Year))

[agni_gold]

No friend ,

Actually when i select year then Account will not sort, and when i select account year may sort .

[evan_kurowski]

Agnivesh Kumar wrote:

Hi Experts ,

Is this possible in listbox ,

if i have two different listboxs one is year and other is account , both fields are linked ,

but if i select year then account will not sort by year value .

The wording here allows multiple interpretations.  How about we define some explicit behaviors:

When a selection is made in the field Year, the field Account should sort by _____________

When a selection is made in the field Account, the field Account should sort by ______________

[settu_periasamy]

Hi Agnivesh,

Did you try the State as 'Ascending' in both Listboxes like the below screen shot..

[krishna20]

Hi,

May be this?? Select Ascending or Descending depends on requirement.

[avinashelite]

write a expression for the sorting and check on the LOAD on STATE ..if your still facing issues please provide the sample app.