topic list box in Qlik Learning Discussions

list box

mario-sarkis — Wed, 21 Jan 2015 14:42:49 GMT

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,

Gysbert_Wassenaar — Wed, 21 Jan 2015 14:55:06 GMT

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

mario-sarkis — Wed, 21 Jan 2015 15:00:35 GMT

Thank You it Works:)