topic Re: Hide Null Value From Listbox in QlikView

Hide Null Value From Listbox

haberinyok — Thu, 16 Jul 2020 08:00:10 GMT

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.

Re: Hide Null Value From Listbox

Durgadevikumar — Thu, 16 Jul 2020 09:47:52 GMT

Hi,

You can use expression in list box,

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

Regards,

DurgadeviKumar

Re: Hide Null Value From Listbox

Kushal_Chawda — Thu, 16 Jul 2020 09:52:40 GMT

try below expression in listbox

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

Re: Hide Null Value From Listbox

haberinyok — Thu, 16 Jul 2020 10:18:54 GMT

in expression in the listbox? you sure?

same problem....

Re: Hide Null Value From Listbox

Kushal_Chawda — Thu, 16 Jul 2020 10:25:15 GMT

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

Re: Hide Null Value From Listbox

haberinyok — Thu, 16 Jul 2020 10:29:00 GMT

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

Re: Hide Null Value From Listbox

Smeenakshi23 — Thu, 16 Jul 2020 10:34:51 GMT

Hi,

Try the below condition in list box expression.

if (field <> '',field)

Re: Hide Null Value From Listbox

Smeenakshi23 — Thu, 16 Jul 2020 10:37:01 GMT

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

Re: Hide Null Value From Listbox

haberinyok — Thu, 16 Jul 2020 10:43:31 GMT

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

Re: Hide Null Value From Listbox

Smeenakshi23 — Thu, 16 Jul 2020 10:47:42 GMT

Re: Hide Null Value From Listbox

haberinyok — Thu, 16 Jul 2020 10:51:01 GMT

God Thanks,

i appreciate that x 1000000000000

thank you very much.