Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I replace a hyphen with a blank ?


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

MV

1 Solution

Accepted Solutions
preminqlik
Specialist II
Specialist II

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

View solution in original post

6 Replies
Not applicable
Author

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

preminqlik
Specialist II
Specialist II

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

Not applicable
Author

Use the Function Alt,

alt(Country,' ')

Regards,

Prabhu

ferha_jafri
Partner - Creator III
Partner - Creator III

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.

Not applicable
Author

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 !

Not applicable
Author

Just what I wanted. Thank you !