topic Function fix the order value in QlikView

Function fix the order value

Black_Hole — Sat, 16 Nov 2024 20:51:22 GMT

Hello all,

I would like to display the value ranked in ascending order in my "Period" list box.

Because, in my current list box, the order depend on the availability of the value in the table like below:

What function can I add in my expression in order to avoid this mess in my list box?

Thank you in advance for your help.

Re: Function fix the order value

sultanam — Thu, 16 May 2019 11:30:04 GMT

Hi,

You need to deselect the 'State' in Sort properties of list box and just select the Numeric Value Ascending in Period list box.
PFA

Regards,
Sultan

Re: Function fix the order value

Black_Hole — Thu, 16 May 2019 11:34:04 GMT

Hello @sultanam ,

Thank you very much for your help.

I try it and now my value are correctly ranked. 👍