clear 'always one selected value' filter on another sheet

[#1]

Hi,

Suppose I have a filter on a sheet where we have turned on the option 'always one selected value'. Now on another sheet, I have another set of charts, and I dont want the always one selected filter option and want to clear it, can someone please tell me how to do it. On both sheets, we are using same filed but on one sheet the list box is set to always one selected value, while on the next sheet, I want to have the ability to select multiple values

Regards

Arif

[jpapador]

If you are using QV11, turn on alternate states and change the list box and chart that you want the selections to a different state.  If you still want the rest of the selectors to work on the page in a different state with set analysis in your chart expression you can do for example Year = $::Year, Month = $::Month.

If you are using QV10 just duplicate the field in the script so it would look like this,

TestTable:

LOAD

Value,

Value as ValueAlt

[#3]

Hi,

Can you please give me an example how to do this

Arif