Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
ECEUKQLIK
New 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

1 Solution

Accepted Solutions
Frank_Hartmann
Honored Contributor II

Re: Adding punctuation to an expression

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

2 Replies
Frank_Hartmann
Honored Contributor II

Re: Adding punctuation to an expression

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

ECEUKQLIK
New Contributor

Re: Adding punctuation to an expression

Hi Frank

Works a treat. Thank you.

Regards

Ellis