can anybody explain this ??

[vishalgoud]

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,,

[kaushiknsolanki]

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/se...

Regards,

Kaushik Solanki

[MK_QSL]

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,

MK

[sasiparupudi1]

This is a parameterised variable. Please check out

Qlikview Parameterised Variables