Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data like
Region
Int'l Americas
But I have to rename this to Americas so I am using below expression but that give me error...
If(Region =' Int'l Americas','Americas') as Region
Qlikview doesnt like this .how do I resolve this sissue ?
You can escape the ' in your string by putting another ' before it:
If(Region = 'Int''l Americas','Americas') as Region
try this in script:
If(Region ='Int'&Chr(39)&'l Americas','Americas') as Region
hope this helps
You can escape the ' in your string by putting another ' before it:
If(Region = 'Int''l Americas','Americas') as Region
Thank you:)