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: 
Anonymous
Not applicable

Empty values in are not listed in a listbox

Hi,

in listbox should be able to be selected only certain values for example: prod1, prod1, ZERO. ZERO may not be indicated in listbox.

Regards Stefan

7 Replies
Anonymous
Not applicable
Author

can this script also using also in a chart?

vikasmahajan

You want to display Fix values?

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

Hi stefen,

I can't get your requirement clearly can you please give some detail or please post your sample file

Thanks and Regards,

S.Amuthabharathi

AbhijitBansode
Specialist
Specialist

Hi,

Empty/Null values are not shown in the list box.

hence you cannot select them.

However, you can use techniques like NullInterpret and NullDisplay to assign meaningful strings to Null value and then can select them in the List Box.

Hope this solves your doubt..

Not applicable
Author


Hi,

Please try this IF(IsNull(field) or field=' ',Unknown,Field) AS Field

then you can get the empty values with the name unknown in list box.  I hope it helps you

Anonymous
Not applicable
Author

It doesnt work? Garbage after expression "AS" NULL should be not listed in the box.

IF(IsNull(ncc_focus) or fncc_focus=' ',Unknown,ncc_focus) AS ncc_focus

Listbox.PNG

AbhijitBansode
Specialist
Specialist

Use below:

If ( Len(ncc_focus)>0, ncc_focus, 'Unknown' ) AS ncc_focus

this should work.