Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Partner
Partner

how to use ' symbol as text?

Hello! I need generate string like onClick="window.open('LINK'), where LINK is gegenrated link from formula, onClick="window.open(' and ') is fixed text parts. Touble with ' symblos around LINK.

When i'm tryen something like 'onClick="window.open(''&LINK&'')', formula does not work. How i can bypass it?

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: how to use ' symbol as text?

Use Chr(39) instead. For example, to get:

Hello my name is 'Jason'

use

='Hello my name is ' & Chr(39) & 'Jason' & Chr(39)

Hope this helps,

Jason

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: how to use ' symbol as text?

Use Chr(39) instead. For example, to get:

Hello my name is 'Jason'

use

='Hello my name is ' & Chr(39) & 'Jason' & Chr(39)

Hope this helps,

Jason

View solution in original post

Highlighted
Partner
Partner

Re: how to use ' symbol as text?

Yes, it works, thanks)

Highlighted
MVP
MVP

Re: how to use ' symbol as text?

Alternatively, you can also use escape sequences:

Escape sequences

='Hello my name is ''Jason'''