topic Re: How do I replace a hyphen with a blank ? in QlikView

How do I replace a hyphen with a blank ?

Tue, 27 May 2014 07:53:58 GMT

Hi All,

I have a text object on a dashboard which displays a Country field thus, =[Country]

However, if the country value doesn't exist, or is not applicable to the selection then a hyphen is displayed -

How can I replace the hyphen in this instance with a blank space ?

Thanks in anticipation

Re: How do I replace a hyphen with a blank ?

Tue, 27 May 2014 08:08:34 GMT

On Chart Properties->Presentation Tab ->replace the hyphen in null symbol and missing symbol by space

Re: How do I replace a hyphen with a blank ?

preminqlik — Tue, 27 May 2014 08:12:24 GMT

=if(isnull(Country),' ',Country)

Re: How do I replace a hyphen with a blank ?

Tue, 27 May 2014 08:12:35 GMT

Use the Function Alt,

alt(Country,' ')

Regards,

Prabhu

Re: How do I replace a hyphen with a blank ?

ferha_jafri — Tue, 27 May 2014 08:59:05 GMT

right click-properties-presentation then remove null symbol - and missing value - with blank and you will get it by removing the hyphen put a space and hit enter you will get blank.

Re: How do I replace a hyphen with a blank ?

Tue, 27 May 2014 09:19:38 GMT

Hi,

I'm confused. A text object doesn't have a Presentation tab. And I can't find the null symbol you're talking about either !

Re: How do I replace a hyphen with a blank ?

Tue, 27 May 2014 09:25:39 GMT

Just what I wanted. Thank you !