Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Set specific row / field value in a table

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

Best,

Sunny

View solution in original post

3 Replies
Highlighted

Re: Set specific row / field value in a table

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

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

Highlighted
Contributor III
Contributor III

Re: Set specific row  / field value in a table

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

Thank you so much! 🙂

Highlighted

Re: Set specific row / field value in a table

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

Best,

Sunny

View solution in original post