topic List Box with blanks in QlikView

List Box with blanks

rido1421 — Wed, 07 Jan 2015 08:42:58 GMT

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

Re: List Box with blanks

tresB — Wed, 07 Jan 2015 08:47:26 GMT

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

Re: List Box with blanks

rido1421 — Wed, 07 Jan 2015 08:59:39 GMT

Thank you works perfectly