Hide Null Value From Listbox

[haberinyok]

Hello everybody, 

i saw a lot of solution about this topic but ne one doesnt work out for me, i couldnt. 

my listbox at the bottom which has null values under the "KİŞİ SAYISI"

the data came from excell. and there are some null values its ok but i shouldnt see them on my listbox.

what should i do? 

This listbox name is : KPI

fyi.

thanks.

[Durgadevikumar]

Hi,

You can use expression in list box,

= if( len(Field)>0, Field)

Regards,

DurgadeviKumar

[Kushal_Chawda]

try below expression in listbox

= aggr(if( len(trim(Field))>0, Field),Field)

[haberinyok]

in expression in the listbox? you sure? 

same problem....

[Kushal_Chawda]

Not in the expression tab. It is where you have list of all fields there is expression as well in the bottom of the list

[haberinyok]

i dont get it. sorry. you mean "edit script" area?

[Smeenakshi23 · Accepted solution]

Hi,

Try the below condition in list box expression.

if (field <> '',field)

[Smeenakshi23]

Right Click  --- > Select List box---> There will be drop down for selecting fields . In that select expression and give the condition

[haberinyok]

here? **bleep**, i feel like im an idiot.

[Smeenakshi23 · Accepted solution]