Show specific Values in chart on click of Multi Box

[#1]

Hi Friends can any one help on displaying Charts on selection of Values in Multi Box.

I have a Multi Box with Region Name values in it are"CHN,IND,US,UK".I need to display a pie chart on selection of US in Multi box as separate chart and on selection of rest of countries a separate Pie chart show except US data.

How to achieve this keeping two pie charts and based on selactions Pie chart should display?Please do needful excepting a good solution.Attaching a Test.qvw

Thanks

[Anonymous · Accepted solution]

to show only US  or containing US

use SubStringCount(Concat([Region Nm],'|'),'US')

and for any except US use below condition

not(SubStringCount(Concat([Region Nm],'|'),'US'))