topic QlikSense showing &amp;amp for & in App Development

QlikSense showing &amp for &

michael_andrews — Sat, 16 Nov 2024 06:52:09 GMT

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 &amp;amp; A Services Inc/Painting &amp;amp; Design

How do I fix this?

SpaceBase3000 — Mon, 14 Jan 2019 15:30:16 GMT

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, '&amp;', '&')

Brgds