5 Replies Latest reply: Mar 6, 2018 4:43 PM by David Forest

# need help

Hi,

I need help on ignoring selections.

I have pie chart

with

dims-->Zone,counrty

and

measure--->Sum(distinct {<Year={"\$(=\$(_vCurrentYear))"},Brand=>}volume)

My requirement is : If I select any country in pie chart, it shouldn't be effect in other chart(bar chart)

In Bar chart

dim--->Country&'-'&Brand

and

Measure1--->

(((Sum({1<Measure=,[KPI Type]={"Volume"},KPI={"B F C"},

BF_Year={"\$(=\$(_vBFCurrentYear))"}>}BF_Volume))/1000)

/

((Sum({1<Measure=,[KPI Type]={"Volume"},KPI={"B F C"},

BF_Year={"\$(=\$(_vBFLastYear))"}>}BF_Volume))/1000)

-1)

*100

Measure2--->

(Sum({1<Measure=,[KPI Type]={"Volume"},KPI={"B F C"},

BF_Year={"\$(=\$(_vBFCurrentYear))"},Country>}BF_Volume))/1000

I tried with Country= under the set expression but not working

any suggestions???

• ###### Re: need help

Hi satish

try replace the Identifier "{1<" to "{\$<" in the expression and add Country= i set analysis.

/Teis

• ###### Re: need help

Yes I tried the same as you suggested.but still not working...

• ###### Re: need help

You shouldn't need to use 1 unless you want all other dimensions excluded.

To exclude a dimension you would add Country= with the qualifier set to \$ instead of 1

Any of the variables,\$(_vBFLastYear),\$(_vBFCurrentYear) used would also need that exclusion added

You may need to exclude other dimensions as well based on your data; it may look like Country is changing the values, but it may be some other dimension like Zone.

• ###### Re: need help

Hey Thank you for suggestion

these are the variables which I have created

\$(_vBFCurrentYear):

Only([Forecast Start Year])-1

\$(_vBFLastYear):

Num(Only([Forecast Start Year])-2,'####')

also I tried with with counry=, zone= in the set expression but still no use.

any suggestions on my expression ??

• ###### Re: need help

Would need sample data to help further; including all the data tables involved. Are you copy and pasting from your app the exact code?

Also noticed upon looking again, do you really want a Sum of distinct volumes in pie?

Is there a volume and BF_Volume?

Why does _vBFLastYear have a num() and _vCurrentYear not?

Set analysis is very finicky, be sure every piece/variable evaluates as expected by placing values in a text object. Poorly formed Set Analysis may syntactically check but yield an empty set or have no effect if the expression evaluates to null