Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lishuang
New Contributor III

sum({$<Region = > }Sales)?

Hi all,

I want to know the different between sum({$<Region = > }Sales) and sum({<Region = > }Sales)?

Thanks in advance!

1 Solution

Accepted Solutions
Highlighted

Re: sum({$<Region = > }Sales)?

Both are same.

Without Dollar Sign is actually applies $ over there. Thats default in Qlikview.

$ - represents current selection

To say

If you leave that place empty means, qlikview by default adds $ in that place and evaluates the expression.

5 Replies
Highlighted

Re: sum({$<Region = > }Sales)?

Both are same.

Without Dollar Sign is actually applies $ over there. Thats default in Qlikview.

$ - represents current selection

To say

If you leave that place empty means, qlikview by default adds $ in that place and evaluates the expression.

roharoha
Valued Contributor III

Re: sum({$<Region = > }Sales)?

I'm not sure, if this also applies to alternate states.

Then I think "$" and the default state is not always the same.

Re: sum({$<Region = > }Sales)?

Yeah. in case of Alternate states

sum({<Region = > }Sales) is based on object state but sum({$<Region = > }Sales) will refer to the default state not based on the objects state.

kalyanivintha1
Contributor II

Re: sum({$<Region = > }Sales)?

hi.,

Both the expressions are going to give you the same results....

without any Identifier..it is treated as a $(Identifier) in set analysis of Qlikview

and

$ gives the current selections as a result

deepak_km9886
New Contributor III

Re: sum({$<Region = > }Sales)?

By default the Qlik engine adds the $(Identifier) in place. So both the expressions evaluates the same result.

Community Browser