topic Removing a - from a table. in QlikView

Removing a - from a table.

amars — Wed, 20 Jul 2011 01:54:06 GMT

Hi all,

I am able to remove the "-" from a chart by going to the presentation tab & removing the "-" from the Null Symbol text box. Now I wish to do the same for a Table box . How shoul I do that.? Please suggest. Thanks in advance.

Amar

Removing a - from a table.

mike_garcia — Wed, 20 Jul 2011 02:26:25 GMT

Go to Properties > Fields > Select your field and mark "Omit Rows Where Field is Null".

Mike

Removing a - from a table.

Wed, 20 Jul 2011 04:32:55 GMT

Hi,

You can skipp blank in script it self. Take null as space in script.

isnull(field,' ')

Removing a - from a table.

montubhardwaj — Wed, 20 Jul 2011 07:37:21 GMT

You can filter it in the script as well:

Load a,b,c

From abc

where a<>'';