Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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_P
Creator II
Creator II

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