Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Black_Hole
Creator II
Creator II

Function fix the order value

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:

Capture.PNG

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.

Labels (4)
1 Solution

Accepted Solutions
sultanam
Contributor III
Contributor III

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

View solution in original post

2 Replies
sultanam
Contributor III
Contributor III

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

View solution in original post

Black_Hole
Creator II
Creator II
Author

Hello @sultanam ,

Thank you very much for your help.

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