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

Listbox

Hello Experts

I have a listbox which shows all the values that are in my table exept for empty field. Is it possible to show the empty fields in the listbox, too? I would like to select the datasets that contain no values in this table through the listbox...

Thank you for your help!

18 Replies
Anonymous
Not applicable
Author

Hi Jan,

You have to write the script outside of the load statement,

NullAsValue Jobkriterium;

Set NullValue='NA';

load *;

SQL SELECT bez as Jobkriterium,

    beznr as Jobkritnr,

    bezart

FROM EASY.divbez where  bezart = 9;

Not applicable
Author

Cool! This one works, exept that it does not give me "NA" values.

Not applicable
Author

Hi Allesandro

Thank your for your help.

I am not sure if I enter the code at the right lace since it duplicates my values in the listbox. Do I enter it under the header 'formula'?

Best

Jan

Anonymous
Not applicable
Author

It means, specified field doesn't have NULL value. Attachment for your reference.

Not applicable
Author

Ok. If I read the fields that are empty into a table it shows '-' what else could be in these fields? 0?

Sorry for keeping you busy on this...

alexandros17
Partner - Champion III
Partner - Champion III

In general tab of the listbox, in the "Field" at the bottom you find expression. Do not use the tab expression otherways as you said you have duplicated values

Anonymous
Not applicable
Author

If it is NULL, it will show '-' in tablebox. If you are using field in expression, for example Sales field has some null entry and if you use Sum(Sales) than it will give you 0.

Not applicable
Author

Hi,

you need to assign the value for null to select them

just use

NullAsValue *;

SET NullValue ="NA";

tablename:

Load

....

...

;


Anonymous
Not applicable
Author

Hi,

Use Nullasvalue concept and you will get the required output in the listbox

HTH

Ravi N.