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: 
evgeniystuchalk
Partner - Creator II
Partner - Creator II

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
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

Yes, it works, thanks)

swuehl
MVP
MVP

Alternatively, you can also use escape sequences:

Escape sequences

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