Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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