List Box Values (Null Values)

Thu, 22 May 2014 11:58:06 GMT

Hi - I have an issue where the data I have looks like the below:

ID Fruit Type

1 Apple

2 Banana

4 Pear

5 Apple

7 Pear

8 Banana

Right now, the list box only offers the following values: Apple, Banana and Pear

However, I want it to list: Apple, Banana, Pear and - / null value / undefined (however it can be displayed)

My developer is telling me that this would be a considerable fix, but based on my designer training, I get the feeling this is more of a setting than anything else. Can someone please help?

Re: List Box Values (Null Values)

tresB — Thu, 22 May 2014 12:02:00 GMT

Use NullAsValue in the script.

Example:

NullAsValue A,B; // A,B are fields

Set NullValue = 'NULL' ;

topic Re: List Box Values (Null Values) in QlikView

List Box Values (Null Values)

Re: List Box Values (Null Values)