How to Handle apostrophe character in Qlik sense

[Sree_1]

For example:

I have a word consists of apostrophe character(e.g : don't) in my sentence, apostrophe is not acceptable while running a script but I want the special character to be displayed in my sentence. Can anyone help me out?

Thanks in advance!!

[alexpanjhc]

try 'don' &chr(39)& 't'

[Digvijay_Singh]

Can you share the exact statement where you need help?

[Sree_1]

Thanks for replying back!!

Sure! I have data in my excel file consists of a sentence 'Can't validate without credentials', when I am trying to fetch data into any charts in the dashboard it is showing blank due to the special character " ' ",  so how can I display the sentence in dashboard? Any help regarding above concern will be appreciated!!

[Sree_1]

Thanks for the response!

I have already tried it but its not working still popping up some error.

[Digvijay_Singh]

Please share your script statement

[Digvijay_Singh]

Tried in filter pane, worked okay in Nov 2021 version

[Sree_1]

I want this in word cloud chart

[Digvijay_Singh]

Whats version you are in, working fine for me

Are you doing something different than what I have shown? 

[Sree_1]

Can you please share me the script once