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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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