Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Dollar sign expansion using expression - differences between script and object formulas

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
kuba_michalik
Partner - Specialist
Partner - Specialist

Dollar sign expansion using expression - differences between script and object formulas

Last Update:

Aug 30, 2019 8:16:00 AM

Updated By:

kuba_michalik

Created date:

Aug 30, 2019 8:16:00 AM

Perhaps this is common knowledge (still not documented anywhere, though, and I'd say the official documentation is downright confusing regarding this), but dollar sign expansions of this type:

$(=Expression)

work in object formulas, but don't work in the load script. In script, they always evaluate to null/empty string.

There is one exception though - if the expression is a single number literal, it will work. So this:

$(=123)

will still evaluate to the number 123, no matter if used in script or in the frontend.

 

This can be occasionally useful if you have defined a variable which takes other variables' names as parameters, which are then called with $($1) syntax. If you replace one of the parameters with e.g. =123, you can pass a numeric constant as a parameter instead of having to use a variable.

Labels (1)
Contributors
Version history
Last update:
‎2019-08-30 08:16 AM
Updated by: