Skip to main content Skip to complementary content
Close announcements banner

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.

Example:  

$(=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.

Example:  

$(include=C:\Documents\MyScript.qvs);

Dollar expansions and alternate states

A dollar expansion is normally not sensitive to alternate states. There is one exception, if the dollar expansion has an expression, this is evaluated in the state relevant to the object where the dollar expansion is made.

Example:  

You have a dollar expansion like the following:

$(=Sum(Amount))

The calculation will return the sum of amount based on the selection in the state of the object.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com