Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In country filter and I have excluded UK by using below condition
=If(Match(Country,'UK'),Null(),Country)
Also In the chart expression I have excluded Country UK
by using setanalysis{<Country=-{'UK'}>}
dim: Country
exp; Sum({<Country=-{'UK'}>}VAL)/SUM({<Country=,brand=>}Total VAL)
Now If select any other Country in filter box
then chart is not showing anything(Only its showing '-').
Problem with expression in the list box
If I remove the condition from list box that is working fine
my dim and exp is some thing like below
dim: Country
exp; Sum({<Country=-{'UK'}>}VAL)/SUM({<Country=,brand=>}Total VAL)
Please suggest where I did wrong.
Any suggestions will be appreciated.
Thanks
Hi,
would you be able to share sample app? I've created a test app with the same filterbox (same expression) and same chart (with same expression) and it is working fine.
maybe there is something else missing which is not described above.. ?
In set expression try like this by placing - symbol before = i.e -=
{<Country-={'UK'}>}
Issue with in list box when I select any Country then all the values are going off in the corresponding chart.
I have excluded Country UK in both list box and Chart
In the Country list box I have used below condition
=If(Country='UK',null(),Country)
dim is Country and Brand
and expression is
(sum( {<[Respondent Dim Key%]=e({$<[Brand Net Multiplier]={'-1'}>}),Year=,Month=,Brand=,Country=-{'UK'},
[Measure ID]={1000},Yardstick={'R3M'},ComparisonType={"None"}>}
[Respondent Weight])
/
Sum( {<[Measure ID]={327},Country=,Brand=,[Imagery ID]=,[KPI Name]=,[Top Statement?]=,Ys={'R3M'}>}
Total<RollingMonth,Brand> [Respondent Weight]))*100
Kindly help as so needful.
Try this,
Dim: Country
exp; Sum({<Country={'*'}-{'UK'}>}VAL) / SUM({<Country=,brand=>}Total VAL)
you can even select UK in the country Listbox but it will display Zero as it becomes empty set.
Thanks,
Please suggest did I wrong anything in both expressions ???