topic Blanks in a Multi-Box in QlikView

Blanks in a Multi-Box

Tue, 05 Mar 2013 16:14:30 GMT

How can I get the blanks to show up as an option in one of my drop down menus in my multi-box? I have columns with "Yes" and blanks that represent no for that attribute. In the multi-box, I can only select the cells with "Yes", and I can't find a way to show just the blanks. I want to be able to select the blanks in the multi-box, without having to go and type in "no" for all of the blanks. That way I can search for items without those attributes.

Re: Blanks in a Multi-Box

Gysbert_Wassenaar — Tue, 05 Mar 2013 16:40:54 GMT

That's because the blanks (aka Nulls) cannot be selected. You'll have to replace them with real values in the script. The NullAsValue keyword and the NullValue variable may be of use.

NullAsValue *;

SET NullValue='No' ;

Load * from ...somewhere...;

See the help file for details (search for NullAsValue or Null Value Handling).