Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stop Dollar Sign Expansion in the script (Escape Character ??? )

Hi there !

I have a problem in my script with the dollar sign expansion (eg. $(...))

To be quick, would like to know if there exists a way to stop the dollar sign expansion in my script. Is there an escape character ?

I explain :

let A = $(Today())

will evaluate the function so that A = 04/03/2010

I would like A to kepp the text : A = $(Today())

I tried the following, but It doesnt work :

let A = '$(Today())' --> just gives '04/03/2010'

let A = $$(Today()) --> just gives $04/03/2010

let A = \$(Today()) --> just gives \04/03/2010

Is there a solution ?

13 Replies
Lauri
Specialist
Specialist

Still a valid solution 5 years later!

ben_pugh
Creator
Creator

yep, I'm still using this, too!

kjhertz
Partner - Creator
Partner - Creator

Actually you can simplify this somewhat and remove the first & surrounding the $-sign:


LET variable = 'only({$<Sales={"$'&'(#=max(Sales))"}>} Town)';

mjperreault
Creator
Creator

Does this still work with newer versions of Qlik Sense.  When I try this using June 2019 

SET A = $(Today())

 

A = <NULL>

 

 

clipboard_image_0.png