Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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.
The phrase include two double quotes on the either side of the text?
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
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
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!