It's not clear to me what you added to which alternate state. If you have a chart for France and added it to myFranceState did you hard code the countryID to France in the chart expressions? If not it will show data for all the countries unless you select France in an object assigned to the same alternate state. Selecting France in a listbox in the default state won't be applied to objects in other alternate states.
Why not put a country list box on the dashboard? That way the user can select any country and the entire dataset is filtered accordingly. All objects reflect the filtered dataset (other than those that explicitly override the country selection using the set expression above).
If you would like to automatically select a country based on some sort of trigger, you can use an action to make the country selection automatically, and again the all the data would be filtered.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
To be honest none do exaclty what I want, but at least it tells me that I might be asking something 'not normal' and maybe I might need to rethink my plan.
Jonathan, yes this works... but I really wanted something hard-set, rather than an option that users can fiddle with. This chart/table must always only show France, and another chart/table pair must always show 'Germany' etc ..
Rupert, again, it would work, but I have 100+ fields in my data... so to create each field a san experission would be a nightmare to maintain. I will have < 10 of these to set up, so that's 500+ fields to wite as individiual expressions.
Again, I'm new to QV so I might be expecting too much ... but I'm suprised there isn't a more simple straight forward way to create a subset of data that you can then feed from.