Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lishuang
Contributor III
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
CELAMBARASAN
Partner - Champion
Partner - Champion

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.

View solution in original post

5 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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
Not applicable

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

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

CELAMBARASAN
Partner - Champion
Partner - Champion

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
Not applicable

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

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