Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to add a filter onto my document where the selections only affect the data in that one chart, and no others, but still have all the other filters effect it and others as normal. Is it possible to do this using alternate states?
So for example,
In my document i have two charts (chart 1, chart 2) and two list boxes (lb1, lb2). For chart 1 i want it to only be affected by selections in lb1, but chart 2 should change with selections in both lb1 and lb2
You can do this before alternate state as well:
Chart 1's expression will have this as a set analysis:
{<lb2field = >} and this will force the expression to now change when you make a selection in lb2 list box.
HTH
Best,
Sunny
You can use set analysis expressions for this. You'll have to decide how the alternate states should interact.
Sum( {AltState1 + AltState2} Value)
Sum( {AltState1 - AltState2} Value)
Sum( {AltState1 * AltState2} Value)
Sum( {AltState1 / AltState2} Value)
+ Union: Returns the set of all records that belong to the unioned sets
- Exclusion: Returns records that belong to the first but not the other of the two set identifiers.
* Intersection: Returns records that belong to both of the set identifiers.
/ Symmetric Difference: Returns a set that belongs to either, but not both of the set identifiers.
Please find attached a sample