What dos {$1} in the modifier do in Set Analysis

[bwisealiahmad]

This might be a really simple question, but I am hoping someone can point me in the way of some good documentation on this.

I've seen examples where {$1} is used in the moderator. What exactly does this mean?

Example could be

Sum({<Account = {$1}, Company = {$2}>}Sales)

Thanks.

[MK_QSL]

I never came across like this...

Account = {$1}

[sunny_talwar]

Here you go....

[bwisealiahmad]

Correct. First example. So it's called variables with parameters?

[sunny_talwar]

I believe so... look at the attached sample....

[MK_QSL]

Got it...!!!

Very true..

[petter]

$1 can have two different meaning depending on where it is:

1) As a parameter inside a $-sign variable    var1='$1*$2'            and    $(=var1(3,27))      will return 3*27 or 108

      Here it is a parameter number $1 is parameter 1 from the caller $-sign expansion

2) As meaning previous selection as noted from others. Then it is called a SET IDENTIFIER  a sibling of $ and $2, $3 ....

The way you posed the question Ali as {1} it means the first.

[Anil_Babu_Samineni]

Sunny, It's interesting. As manish said i am also new to here. Anyhow, But how filter values are showing in expression even we use Variable here. Can you point out and help me on this

[sunny_talwar]

Its using this concept of Variables with Parameters

[MK_QSL]

Check the variable definition used in this expression..

[bwisealiahmad]

Hi again Sunny,

First of all thanks for the answer. This is what I was looking for. Do you know if this has any sort of memory saving or any better functionality in heavy straight tables? Moving the IF statement to a variable and then use parameters and variables in straight table?