Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
haberinyok
Contributor II
Contributor II

Hide Null Value From Listbox

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.

listbox.jpg

2 Solutions

Accepted Solutions
Smeenakshi23
Creator II
Creator II

Hi,

Try the below condition in list box expression.

if (field <> '',field)

List box.PNG

View solution in original post

10 Replies
Durgadevikumar
Partner - Contributor III
Partner - Contributor III

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
Contributor II
Contributor II
Author

in expression in the listbox? you sure? 

same problem....

STİLL.jpg

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
Contributor II
Contributor II
Author

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

Smeenakshi23
Creator II
Creator II

Hi,

Try the below condition in list box expression.

if (field <> '',field)

List box.PNG

Smeenakshi23
Creator II
Creator II

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

haberinyok
Contributor II
Contributor II
Author

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

keremthy_0-1594896192468.png