Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
krissy_s
Contributor III
Contributor III

Set specific row / field value in a table

Hello

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 🙂

1 Solution

Accepted Solutions
sunny_talwar

Awesome, please close the thread by marking the correct response.

Best,

Sunny

View solution in original post

3 Replies
sunny_talwar

Have you tried this with the Escape sequences (two single quotes)

=if(Match(Risktype,'Liability - Professional Indemnity Lloyd''s'), RiskType)

krissy_s
Contributor III
Contributor III
Author

Yay!! It worked! (I didn't know about Escape Sequences).

Thank you so much! 🙂

sunny_talwar

Awesome, please close the thread by marking the correct response.

Best,

Sunny

View solution in original post