topic Re: List box sorting in QlikView

List box sorting

agni_gold — Sun, 11 Oct 2015 16:26:48 GMT

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 .

Re: List box sorting

evan_kurowski — Sun, 11 Oct 2015 16:45:45 GMT

Hello Agnivesh,

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

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

Re: List box sorting

agni_gold — Sun, 11 Oct 2015 17:33:50 GMT

No friend ,

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

Re: List box sorting

evan_kurowski — Sun, 11 Oct 2015 23:59:01 GMT

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 ______________

Re: List box sorting

settu_periasamy — Mon, 12 Oct 2015 01:57:17 GMT

Hi Agnivesh,

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

Re: List box sorting

krishna20 — Mon, 12 Oct 2015 06:40:36 GMT

Hi,

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

Re: List box sorting

avinashelite — Mon, 12 Oct 2015 06:56:13 GMT

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