Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Escape character for special character in Calculated Dimensions

Is there an escape character for special character in Calculated Dimensions (in Pivot Table), similar to \ for Python strings ?

I heard that I can use Chr(n) for special character in the script, but this is not working for calculated dimensions...

Thanks in advance

4 Replies
hic
Former Employee
Former Employee

No, there is none (yet). What do you want to do?

HIC

Not applicable
Author

thanks for reply

I would like to have in a calculated dimension a pick(match('Val1', 'Val2'),'Rep1','Rep2') where 'Rep1' is a string including a single quote, for instance 'Game O'Game'

Thanks

hic
Former Employee
Former Employee

Just write the single quote twice, and it should work. Like 'Game O''Game'

HIC

Not applicable
Author

Thanks i will try so