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

[lishuang]

Hi all,

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

Thanks in advance!

[CELAMBARASAN · Accepted solution]

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.

[Anonymous]

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

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

[CELAMBARASAN]

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.

[Anonymous]

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]

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

[varajpmc0816]

what is the meaning of region=

[saurav12345678]

it will ignore region selection

[hic]

No, no, no.

{$<Region= >} and {<Region= >} are NOT the same.

{<Region= >} uses the context. I.e. if an object is in an alternate state, or if an object has a set expression defined in qContextSet, or if the expression has an outer set expression, this will be used instead of the $.

{$<Region= >} does not use the context. It always uses $ instead of the context.