Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

why we use $ in QlikView?

Hello,

I have one ready made dashboard and I can see some color code on it. When I clicked on any particular color say ORANGE whole dashboard's graph turn into orange. I can see some "environment variable" are also set.

For ex:

Orange.JPG

How can you achieved this change?

Environment variable which are used mostly are "vi_Blue = RGB(255,128,0)" and "vi_Grey= $(vi_Blu)". what is mean by "$(vi_Blu)"?

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

$ doesn't do anything in QlikView. It's just a character that can be used in all sorts of names.

The $(varname) construct on the other hand is an entirely different story. This specification will replace $(varname) with the current content of variable varname (text), as a number (use $(#varname) ) or as an expression to be evaluated before replacing the $() part (.e.g something like $(=Max(OrderDate) in a set expression text value).

You also have a special case that again does something particularly powerful.

$(Include=UnquotedPathToAFile) will replace the whole $(...) shebang with the content of the text file specified by PathToAFile. This is the basic tool to include external script files in other scripts. $(Must_Include=...) will do the same but now forcibly.

Best,

Peter

View solution in original post

4 Replies
oknotsen
Master III
Master III

Here you can find more information about "dollar sign expansion":

http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/dollar-sign-expansions....

May you live in interesting times!
Anonymous
Not applicable
Author

$ means that the expression is evaluated in the new var or in the objetc.

Thanks

oscar_ortiz
Partner - Specialist
Partner - Specialist

You use the $() Dollar sign expansion as a replacement value.  The content of your variable will be used as your replacement value in your visualizations.

Not only variables can be used you can also include the results of a function $(=Max(Year)).

Peter_Cammaert
Partner - Champion III
Partner - Champion III

$ doesn't do anything in QlikView. It's just a character that can be used in all sorts of names.

The $(varname) construct on the other hand is an entirely different story. This specification will replace $(varname) with the current content of variable varname (text), as a number (use $(#varname) ) or as an expression to be evaluated before replacing the $() part (.e.g something like $(=Max(OrderDate) in a set expression text value).

You also have a special case that again does something particularly powerful.

$(Include=UnquotedPathToAFile) will replace the whole $(...) shebang with the content of the text file specified by PathToAFile. This is the basic tool to include external script files in other scripts. $(Must_Include=...) will do the same but now forcibly.

Best,

Peter