Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rido1421
Creator III
Creator III

List Box with blanks

Hi There

I have a list boxes that im using in sort of a hierarchy structure

In the Parent list box I select Car

In the child list box the brands should appear , Toyota,Mazda Etc ,

My Problem is that there are a whole lot of Blanks in the child list box instead of putting the relevant fields at the top of the list box

you find them as you scroll down... I need the relevant available children brands to appear at the top... any Idea what I could of done wrong or can change in the list box?

Regards,

Ridhaa

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Sort tab, sort by expression(ascending), like:

=if(Len(Trim(ChildCarField))>0,ChildCarField)

Or , if you want spaces out of listbox, try the same expression in the general tab->field->expression (as if a calcuation dimension).

View solution in original post

2 Replies
tresesco
MVP
MVP

Sort tab, sort by expression(ascending), like:

=if(Len(Trim(ChildCarField))>0,ChildCarField)

Or , if you want spaces out of listbox, try the same expression in the general tab->field->expression (as if a calcuation dimension).

rido1421
Creator III
Creator III
Author

Thank you works perfectly