Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grey values in list box not at bottom

Hello,

Is there a way to maintain the sort order of a list box / multi box so that grey (non associated) values are not moved to the bottom of the list?

For example, my multi box contains dates and I would like the greyed out dates to remain in their original order in the list, rather than being pushed to the bottom.

Thoughts on how to do this?

Thanks

Mel

5 Replies
Anonymous
Not applicable
Author

On the Sort tab of your List Box, untick <State> under Sort By.  You may well need to tick <Text> or whatever else you wish to sort by.

jpenuliar
Partner - Specialist III
Partner - Specialist III

You probably have the Sort By State ticked On

awhitfield
Partner - Champion
Partner - Champion

On the sort tab of the multibox, select the required field and un-tick 'State'. Repeat for any other fields.

Regard

Andy

awhitfield
Partner - Champion
Partner - Champion

Wow - the Bats are back!

Not applicable
Author

Thanks all,

I have tried to untick 'sort' for each of the lists in my multibox but with little success as of yet.

The main perpetrator is the 'Date' field. If I filter to an individual who doesn't have activity on a certain date, this date is greyed out and moved to the bottom, as in the below example, I would like 1/2/2015 to remain in its place in the list, even though greyed out.

I am currently sorting this list by Numeric Value, Ascending only.

Thanks for all your suggestions!

Mel