Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jeroenlansberge
Contributor III
Contributor III

Special characters in words

Hello,

Question, how do you deal with words containing ' ? For example the word Can't

My text phrase is ""Can't Do"" but once placed in the below mentioned script it gives a error as Qlik sees the ' in can't as a character.

I cannot change the actual text as it is output data from iAuditor.

Count({<Action_Status={'""Can't Do""'}>}Action_ID)

How to deal with these type of words?

Thank you in advance for your cooperation!!

5 Replies
petter
Partner - Champion III
Partner - Champion III

You can escape the single quote by having it twice like this:

'I can''t go to the meeting tonight'

It works for the latest versions of QlikView and Qlik Sense.

sunny_talwar

The phrase include two double quotes on the either side of the text?

praveenkumar_ma
Partner - Creator
Partner - Creator

Hi Jeroen,

Try this , May be Helpful

Count({<Action_Status={'[""Can't Do""]'}>}Action_ID)

or

Count({<Action_Status={'[Can't Do]'}>}Action_ID)

Regards

PM

jeroenlansberge
Contributor III
Contributor III
Author

Dear Petter,

Thanks for your input, nevertheless the problem is that the data (text) is generated automatically so for that i cannot change the input. The positive point is that I have managed to get generated data via API instead of making a csv file within the program and that solved the ' " ' issue and the Can't  issue. It is now generated as cannot

Thanks again for your help

jeroenlansberge
Contributor III
Contributor III
Author

Dear Praveen,

Thank you for your ideas, to be honest i have not tried this as I found a way via API to get the data exported in the correct way without the characters. Nevertheless, i am sure it will be helpful in the future so i will keep the ideas!

Thanks again!