Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
HI @QFanatic
Try like below
if(CostName = 'House API''s & VSP',Value) as [House API's & VSP].
double single quotes will help ..