how to write if condtion with strang containing single quote.

[#1]

Hi All,

I am writing if condition in dimension side but that string already contains special character.

Ex :

if(Particulars='Shareholder's Loans' but it is not giving result because that string already contains single quote.

Hot to avoid it.QlikTech Admin

[tresesco]

Try using double quotes, like:

If( particulars= "Shareholder's Loans" ....

[alexandros17]

try with if(Particulars="'Shareholder's Loans'"

double quotes indicates strings ..

[jsingh71]

if(Particulars="Shareholder's Loans" , <some expression>, <some expression>)

[tresesco]

Or, use chr(39) for single apostrophe, like:

If(Particulars = 'Shareholder'&chr(39)&'s Loans' , ....

[PrashantSangle]

Hi,

Try this

If(Particulars='Shareholder'& chr(39) &'s Loans' )

[kumarnatarajan]

Hi,

Replace the single quotes in both places

If(Replace(particulars,Chr(39),'')= 'Shareholders Loans' ....