QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Dollar-sign expansion using an expression

Expressions can be used in dollar-sign expansions. The content between the brackets must then start with an equal sign:

$(=expression )

The expression will be evaluated and the value will be used in the expansion.


$(=Year(Today())); // returns a string with the current year.

$(=Only(Year)-1); // returns the year before the selected one.

File inclusion

File inclusions are made using dollar-sign expansions. The syntax is:

$(include=filename )

The above text will be replaced by the content of the file specified after the equal sign. This feature is very useful when storing scripts or parts of scripts in text files.



Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?