Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ECEUKQLIK
Contributor
Contributor

Adding punctuation to an expression

I am aware of how to add text to an expression as so:

=IF((Year)< 1935,'Dont care','Do care'))

However I am struggling to add an apostrophe to the word "don't" in my expression.

Your advice is much appreciate

Labels (2)
1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

=IF((year)< 1935,'Don'&Chr(39)&'t care','Do care')

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

=IF((year)< 1935,'Don'&Chr(39)&'t care','Do care')

ECEUKQLIK
Contributor
Contributor
Author

Hi Frank

Works a treat. Thank you.

Regards

Ellis