Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Still a valid solution 5 years later!
yep, I'm still using this, too!
Actually you can simplify this somewhat and remove the first & surrounding the $-sign:
LET variable = 'only({$<Sales={"$'&'(#=max(Sales))"}>} Town)';
Does this still work with newer versions of Qlik Sense. When I try this using June 2019
SET A = $(Today())
A = <NULL>