topic Re: Apostrophe in Field Name value in QlikView

Apostrophe in Field Name value

QFanatic — Thu, 01 Apr 2021 09:28:09 GMT

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 — Thu, 01 Apr 2021 09:55:38 GMT

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 — Thu, 01 Apr 2021 10:42:57 GMT

Try like below

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

double single quotes will help ..