There are multiple sheets in our application and I have a scenario where I have to create a local filter X for a particular chart in a particular sheet 'SheetMain'. The first sheet is application is FilterSheet where we have list of all the filters present in the whole application. This filter X is also present in this FilterSheet where user can select 'Yes' and 'No' value for this.
Requirement is, in SheetMain, the chart should be only visible for filter X -> Yes value. It should not be affected by any selections done for filter X on FilterSheet.
The chart value should alws display value for X-> yes values.
Note: This X filter is also present for user selections in FilterSheet.
X filter should not be set to Yes value for whole application.
I am not sure exactly what you are trying to do, but there are no "local" filters in QV. The filters always filter the entire data set for all chart objects (although you can override or modify selections in individual chart objects using a set expression).
You can create something a little like a local filter by creating an alternate state which can be applied to a sheet object or to a sheet, and you could use one alternate state per sheet, if needed. Then use a show conditional (Properties | Layout for the chart) that refers to the alternate state. Search in the forum for more information on alternate state.