Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
Hi satish
try replace the Identifier "{1<" to "{$<" in the expression and add Country= i set analysis.
/Teis
Hey thanks for your response.
Yes I tried the same as you suggested.but still not working...
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.
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 ??
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