Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

mario-sarkis
Contributor II

list box

dear all have list box it shows like this:

Type
housing
Consumptions
Cars
Education
Credit Cards
Furniture

i need to eliminate the gray  Row  how can i do it any option ?

Thank you,

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: list box

Perhaps your Type field contains a value that's an empty string or only spaces. You can eliminate that in the load script with a where clause:

LOAD Type

FROM ...source...

WHERE Len(trim(Type))>0;


Another option could be using an expression instead of a field name for the listbox: =aggr(Type,Type).


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: list box

Perhaps your Type field contains a value that's an empty string or only spaces. You can eliminate that in the load script with a where clause:

LOAD Type

FROM ...source...

WHERE Len(trim(Type))>0;


Another option could be using an expression instead of a field name for the listbox: =aggr(Type,Type).


talk is cheap, supply exceeds demand

View solution in original post

mario-sarkis
Contributor II

Re: list box

Thank You it Works:)