How do I remove blank values from SearchBox

Mon, 30 Apr 2012 16:20:56 GMT

Hi,

I have one Search Box which contains my values let's say A, B, C plus another one blank line. Is it possible to show only A,B,C and exclude the blank one?

I also have to mention that I can't exclude this from the load script as I need the values to sum up including this blank line.

Thanks!

How do I remove blank values from SearchBox

Oleg_Troyansky — Mon, 30 Apr 2012 17:18:08 GMT

Adina,

you must be referring to the List Box, not to the Search Object, right? I can suggest 3 choices:

1. In the load script, replace empty strings with a text such as "Missing", or "N/A"... This way, your List Box will show 3 valid values and one value that is "missing".

2. In the script, replace empty strings with nulls. Nulls will be excluded from the List Box, while the corresponding numbers still remain in the dataset.

3. In the list box, use a calculated expression, something like this:

IF(len(trim(Field))>0, Field, null())

This might be a bit heavier on the performance side...

cheers,

Oleg

topic How do I remove blank values from SearchBox in QlikView

How do I remove blank values from SearchBox

How do I remove blank values from SearchBox