topic Re: Syntax problem - & chr(39) not working in QlikView

Syntax problem - & chr(39) not working

Wed, 28 Nov 2012 12:20:13 GMT

Hallo,

I need to print this (italian) expression:

Mese dell'anno

I tried to change ' in & chr(39) in the main script but it's not working.

Here the fake and dummy example:

LOAD

if([Apples]>15,'Mese dell& chr(39)anno') as [test]

But as create a listbox with text, I see just the same spellling - no substition happening.

Could anyone please help me?

Please find attached the example.

sivarajs — Wed, 28 Nov 2012 12:27:15 GMT

Try this if([Apples]>15,'Mese dell'&chr(39)&'anno') as [test]

Wed, 28 Nov 2012 12:30:12 GMT

Working great!

Thanks a lot,

Lorenzo