Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rido1421
Contributor II

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
MVP
MVP

Re: List Box with blanks

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).

2 Replies
MVP
MVP

Re: List Box with blanks

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
Contributor II

Re: List Box with blanks

Thank you works perfectly

Community Browser