topic can anybody explain this ?? in QlikView

can anybody explain this ??

vishalgoud — Wed, 25 Nov 2020 16:16:04 GMT

Hi All.

the below highlighted in a not set analysis dollar sing am pretty sure but some parameter, which i am not aware.

in my entire app this kind of expressions are there and am new to this project handling alone. please guide me what it is..

Sum({<$1>}INTER_COST+FINAL_COST) -- how to find its effect and which values are there behind it,,

Re: can anybody explain this ??

kaushiknsolanki — Sun, 29 Apr 2018 06:19:11 GMT

HI,

This ($1) sign is called the Identifier in Set analysis, which means consider the previous selection.

More information is available on help.

Identifiers

Identifiers define the relationship between the set expression and the field values or expression being evaluated.

In our example sum( {$<Year={2009}>} Sales ), the identifier is the dollar sign, $, and means that the set of records to be evaluated consists of all the records of the current selection. This set is then further filtered by the modifier part of the set expression. In a more complex set expression, two identifiers can be combined using an operator.

This table shows some common identifiers.

Identifier	Description
1	Represents the full set of all the records in the application, irrespective of any selections made.
$	Represents the records of the current selection. The set expression {$} is thus the equivalent to not stating a set expression.
$1	Represents the previous selection. $2 represents the previous selection-but-one, and so on.
$_1	Represents the next (forward) selection. $_2 represents the next selection-but-one, and so on.
BM01	You can use any bookmark ID or bookmark name.
MyAltState	You can reference the selections made in an alternate state by its state name.

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-analysis-expressio…

Regards,

Kaushik Solanki

Re: can anybody explain this ??

MK_QSL — Sun, 29 Apr 2018 09:37:55 GMT

I think we have {<>} here and inside these brackets we have $1.

If we don't have set modifier then we don't need <>.

We can simply write Sum({$1}INTER_COST+FINAL_COST) which is for previous selection.

Here we can consider this as Parameter.

Say you have below data.

Load * Inline

[

Name, INTER_COST, FINAL_COST

A,100,120

B,200,300

C,400,500

];

Now if you create variable using below expression

vCost

Sum({<$1>}INTER_COST+FINAL_COST)

So when you call this variable, you can pass something like below.

$(vCost(Name = {'A'}))

So this expression will give you TOTAL COST for Name = 'A' only.

HTH

Regards,

Re: can anybody explain this ??

sasiparupudi1 — Sun, 29 Apr 2018 14:41:49 GMT

This is a parameterised variable. Please check out

Qlikview Parameterised Variables