Discussion board where members can get started with QlikView.
I am trying to set a specific row / field value in my table.
The problem is the specific value has a ' in the field name.
The following will work, no problem: =if(Match(Risktype,'Liability - Professional Indemnity'),RiskType)
But the following will not work: =if(Match(Risktype,'Liability - Professional Indemnity Lloyd's'),RiskType),
an error message is displayed as the name of the field has an apostrophe, in the "Lloyd's" word. As this is a set value in the list I cannot simply remove the apostrophe.
Does anyone have any suggestions please how to deal with the apostrophe please?
Many thanks 🙂
Awesome, please close the thread by marking the correct response.
View solution in original post
Have you tried this with the Escape sequences (two single quotes)
=if(Match(Risktype,'Liability - Professional Indemnity Lloyd''s'), RiskType)
Yay!! It worked! (I didn't know about Escape Sequences).
Thank you so much! 🙂