I have 2 line charts in a sheet. I need to filter those 2 charts with the help of slider. But those filtered slider values should not effect any of the other charts. and also If I want to filter data from any of the other filters it should effect the current chart.
Go into document properties (CNTL ALT D) and create an alternate state. In the properties of the the slider (and the objects you want affected by the slider) set there state to the newly created state (this is on the general tab). "
Also what do you mean by "also If I want to filter data from any of the other filters it should effect the current chart."
Yes alternate states should be able to accomplish this, then for the charts to follow other filters (the default state) you'll need set analysis in your expression like:
when I move the slider other filters and charts should not be affected. Only that particular chart that I want should be filtered. Again when I select an option from other filters that particular chart should need to affected
So the step above is step one. On the charts that will be affected by the slider... In your expression you will need to use set analysis. It would look something like this.
Sum({<Field1=$::Field1, Field2=$::Field2>} Value)
You would put the names of the fields youd want to affect the chart where it says field 1, 2.. etc.
Can you give us some idea what parameters you are trying to filter by? Can you give us a small example or post your app? If they are fields, then this should work:
sum({<Date=$::Date, Product=$::Product>}Value)
You can also set whole chart to the state you want on the general tab, near the chart title.
