Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
avipathak06
New Contributor III

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)"?

Tags (2)
1 Solution

Accepted Solutions

Re: why we use $ in QlikView?

$ 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
Honored Contributor III

Re: why we use $ in QlikView?

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!
manucamon
Valued Contributor III

Re: why we use $ in QlikView?

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

Thanks

Partner
Partner

Re: why we use $ in QlikView?

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)).

Re: why we use $ in QlikView?

$ 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