Why and when $ is used in expressions?

[#1]

Hello guys,

Can anyone tell me clearly 'Why and When to use the "$" symbol in expressions in QV???

Thank you,

[jvitantonio]

You use this when you need to use Set Analysis in a formula. This represents the current selection. For example:

sum( {$} Sales )

returns sales for the current selection, i.e. the same as sum(Sales).

sum( {$<Year = {2000}>} Sales )

returns the sales for current selection, but with new selections both in “Year”

So if you select 2011 this will return the sales for ALL your current selections but instead of using 2011 inthe year, it will use 2000.

I hope this helps.

[#3]

'$' represents the current dataset i.e. filtered dataset based on the selections done by the user. Hence, the formula is evaluated only on the filtered dataset unlike '1' which represents whole dataset i.e. superset (without considering the selections by the users).

Hope this helps.