Discussion board where members can get started with Qlik Sense.
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?
Use Chr(39) instead. For example, to get:
Hello my name is 'Jason'
='Hello my name is ' & Chr(39) & 'Jason' & Chr(39)
Hope this helps,
View solution in original post
Yes, it works, thanks)
Alternatively, you can also use escape sequences:
='Hello my name is ''Jason'''