list box

[mario-sarkis]

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 · Accepted solution]

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]

Thank You it Works:)