Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax problem - & chr(39) not working

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.

1 Solution

Accepted Solutions
sivarajs
Specialist II
Specialist II

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

View solution in original post

2 Replies
sivarajs
Specialist II
Specialist II

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

Not applicable
Author

Working great!

Thanks a lot,

Lorenzo