How to get current selection of the alternate state?

[#1]

Hi,

I have 2 alternate states (Main and sub). How do i get the current field selection of the state in my expression?

Basically i have 2 sheets and I do not want the field selected interfere with each other.

Sum( { [Sub] <[Count A] = $::[Count A]>} [Budget Value] )

I wan to achieve something like

Sum( { [Sub] <[Count A] = [Main][Count A]?>} [Budget Value] )

[#2]

I manage to figure out as the following.

Sum( { [Sub] <[Count A] = { $( = Concat({Main} DISTINCT Chr(39)&[Count A]&Chr(39), ',' ) ) } > } [Budget Value] )

It works but not sure it is the correct way of doing.

[swuehl · Accepted solution]

Have you tried using the scope operator here, too:

Sum( { [Sub] <[Count A] = Main::[Count A] > } [Budget Value] )

or

Sum( { [Sub] <[Count A] = p(Main::[Count A]) > } [Budget Value] )

[#4]

whao. thanks buddy.

I use the scope operator and it works.

Sum( { [Sub] <[Count A] = Main::[Count A] > } [Budget Value] )

[#5]

genieworks

Can you share the sample qvw solution?