Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am facing one issue in one of the expression because of the apostrophe in the filed value.
Expression used in qvw: ='[PD.Coverage] ={"$(=only([%PD.PD.Incumbent]))"}'
PD.Coverage & %PD.PD.Incumbent are the field names in qvw file. This above expression is using as a part of set analysis in some other expression.
This expression is working fine for all the values in %PD.PD.Incumbent field except the values with apostrophe (eg: Workers’ compensation)..
The expression is getting terminated whenever it come across ‘ value and its causing the issue.
Can anyone please help me how to handle this apostrophe value in the expression.
Thanks
Nirmal.
There are no escape characters in QV as far as I know, so you can't use "'" for example. You can substitute chr(39) for any single quote as a workaround.