topic Hide Null Values inside List Box ? in QlikView

Hide Null Values inside List Box ?

Wed, 23 Jun 2010 10:04:39 GMT

Hi;

I would like to hide null values inside list box ?

I researched for properties and functions but i did not find any thing what i can use !!

Please help me...

Thanks in advance

Hide Null Values inside List Box ?

sparur — Wed, 23 Jun 2010 10:09:25 GMT

in ListBox null values suppress automatically. but may be you have empty string or something else... so you can use expression in listbox:

if (Len(YourField) > 0, YourField)

Hide Null Values inside List Box ?

Wed, 23 Jun 2010 13:25:00 GMT

Thank you...

I try it in list box properties, layout, show condition. But it did not work ?

I get datas from oracle DB and in the database some fields are ampty so i dont want to see any fields which are empty...

This is my main problem ???

Thanks in advance

Hide Null Values inside List Box ?

sparur — Wed, 23 Jun 2010 13:57:55 GMT

Why "Show Condition"?

Open properties of your ListBox, on General tab you should to change option "Field" from your YourField into Expression (on top of drop down list) and paste my expression

Hide Null Values inside List Box ?

sparur — Wed, 23 Jun 2010 13:58:56 GMT

or you can remove such data (with empty field) in the script.

Hide Null Values inside List Box ?

Wed, 23 Jun 2010 14:07:50 GMT

Ok. Sorry...

Its my mistake.

It works correctly thanks again...

Re: Hide Null Values inside List Box ?

sateeshkumar — Tue, 23 Sep 2014 11:10:25 GMT

Ya it works fine for not showing null values. but i used this list box field in set analysis to fix the value in text box. so that value is changing by selecting items list box. I need to fix the value in text box with any changes to in list box field. can anyone help to me to get this.

Re: Hide Null Values inside List Box ?

LearnFreak — Tue, 27 Sep 2022 07:53:35 GMT

Hi,

I have the same issue, but in my case I have a Multibox and when I use this solution nothing changes.

Do you have any other idea for Multibox?