Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Highlighted
michael_andrews
Not applicable

QlikSense showing &amp for &

I have a field in the database that is a nvarchar (sql server) with the value

J & A Services Inc/Painting & Design

When it is displayed in qlik it is showing up as

J & A Services Inc/Painting & Design

How do I fix this?

Labels (1)
1 Reply
oscarwerneradve
Not applicable

Re: QlikSense showing &amp for &

Hi,

I think this is more a SQL case than a Qlik case.

Try to use this to get rid of the problem before you extract to Qlik. 

select @str = replace(@str, '&', '&')

 https://stackoverflow.com/questions/10618211/why-does-sql-display-an-as-amp

 

Brgds