Force Listbox Order after Select/Click

[volcore79]

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

[brenner_martina]

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!

[prieper]

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

HTH
Peter

[volcore79]

Hi Martina,

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

v.