topic Force Listbox Order after Select/Click in QlikView

Force Listbox Order after Select/Click

volcore79 — Tue, 22 Feb 2011 12:10:30 GMT

Hi,

in my application i have two fields to select months (2 Listboxes): Normal (Jan - Dec), Fiscal (Jul - Jun). "Normal" has no sorting order,

fiscal ist sorted by a formula:

=if (num(Calender.FiscalMonth)<=6,
num(Calender.FiscalMonth)+6,
num(Calender.FiscalMonth)-6
)

This seems to work.

But everytime i select a fiscal month, the listbox order changes an the selected fiscal month get's the "first" list entry.

The sorting order has to be the same - wether somone clicks/selects a fiscal month or not.. How can i force qlikview to do so ?

Regards

Volker

AW:Force Listbox Order after Select/Click

brenner_martina — Tue, 22 Feb 2011 12:26:06 GMT

Hi, Volker,

it is knwon that sort order in listboxes for expressions does not work fine. better you create a field for the fiscal year (months ond so on). Then it runs fine!

Force Listbox Order after Select/Click

prieper — Tue, 22 Feb 2011 12:29:03 GMT

If the listbox is wide enough to contain all fields without scrollbars, untick "Sort By State" in the sorting-tab.

HTH
Peter

AW:Force Listbox Order after Select/Click

volcore79 — Tue, 22 Feb 2011 12:37:38 GMT

Hi Martina,

i already have fiscal-fields. Doesn't work...