Apostrophe in Field Name value

[QFanatic]

hi all,

I am creating a Calculated Dimension with a field. However, the field contents contains an 's at the back (see code below)

Obviously Qlik doesnt like it....how do I code it, for it to be acceptable as a field name?

My code is..

if(CostName = '[House API's & VSP]',Value) as [House API's & VSP]...

Much appreciated.

[eddie_wagt · Accepted solution]

Hello  @QFanatic 

Use this:

if(CostName = 'House API'&chr(39)&'s & VSP',Value) as [House API's & VSP]

If you face many descriptions/values where there are characters like apostrophe, you could consider to replace these characters.

Regards Eddie

[MayilVahanan]

HI @QFanatic 

Try like below

if(CostName = 'House API''s & VSP',Value) as [House API's & VSP].

double single quotes will help ..