Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try using double quotes, like:
If( particulars= "Shareholder's Loans" ....
try with if(Particulars="'Shareholder's Loans'"
double quotes indicates strings ..
if(Particulars="Shareholder's Loans" , <some expression>, <some expression>)
Or, use chr(39) for single apostrophe, like:
If(Particulars = 'Shareholder'&chr(39)&'s Loans' , ....
Hi,
Try this
If(Particulars='Shareholder'& chr(39) &'s Loans' )
Hi,
Replace the single quotes in both places
If(Replace(particulars,Chr(39),'')= 'Shareholders Loans' ....