topic Set specific row / field value in a table in QlikView

Set specific row / field value in a table

krissy_s — Wed, 25 Nov 2020 16:16:04 GMT

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 🙂

Re: Set specific row / field value in a table

sunny_talwar — Thu, 19 Jul 2018 16:30:43 GMT

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

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

Re: Set specific row / field value in a table

krissy_s — Thu, 19 Jul 2018 21:59:21 GMT

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

Thank you so much! 🙂

Re: Set specific row / field value in a table

sunny_talwar — Fri, 20 Jul 2018 02:11:50 GMT

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

Best,

Sunny