List Box Needs to Retain Ascending Order and Show BLank Value at the Bottom ?

[#1]

Hi,

we have a list box with one blank value in that.

we would need to show list box values in ascending order.

currently, it shows values in ascending order with blank value on the top.

we need to keep ascending order and show blank value very last in bottom of list.

can someone help with that ?

[roger_stone]

One way to do it would be to have a numeric tag to each row and make sure the blank row gets the highest tag:

LOAD * INLINE [

Name, Value

,4

A,1

B,2

C,3

];

Then in the Sort tab of the listbox:

[Anonymous]

Hi,

I guess that isn't possible to sort the list box and put 'the blank' in very last, because it's a default form of qlikview.

But you can treat this blank value in script and put some value on it, like 'null' or 0.0000001.

Best Regards

[maxgro]

maybe playing with the sort order