Force Set Analysis disregarding selection

[#1]

Hello, I'm having trouble using set analysis disregarding the selection the user makes.

On a clear state my table shows like this:

GROUP1	ITEM 1	324
GROUP2	ITEM 1	347
GROUP3	ITEM 1	100
GROUP4	ITEM 1	32
GROUP 5	ITEM 1	250

But when the user selects one of the groups, my table shows like this:

GROUP1	ITEM 1	-
GROUP2	ITEM 1	347
GROUP3	ITEM 1	-
GROUP4	ITEM 1	-
GROUP 5	ITEM 1	-

I want the chart to keep the values as the selection should only affect other charts, not this one.

I'm using the next expression on my chart:

(sum({1<Date={$(vPeriod)},Flag_BAE={1}>}Weight* Flag_YearToDate)/Value)

I've tried other variations:

(sum({1<Date={$(vPeriod)},Flag_BAE={1},ID_Group=,Group=>}Weight* Flag_YearToDate)/Value)

(sum({$<Date={$(vPeriod)},Flag_BAE={1},ID_Group=,Group=>}Weight* Flag_YearToDate)/Value)

but i can't make it work, any ideas?

[swuehl · Accepted solution]

Could you post a small sample app? Maybe you need to use something like

.../ only({1} Value) )

[#3]

Yes, you're correct, the trouble is with the Value. I removed it and moved it to the sum expression and now it works perfect. Thank you  very much for pointing that out!