Automation of changing hard coded values in filter of an expression

[#1]

I have hundreds of expressions.

Every expression has filter say product={'pens','paste','soaps'}.

i created variable say-let v1='pens','paste','soaps'.

I want to replace hard-coded values with variables like:product={$(v1)}.

Pls can any 1 help other than manually going to expression n replacing values with variables; is there any way like to replace hard-coded values in all expressions at once without manually changing them?

[Kushal_Chawda]

why you are not simply selecting the product instead of hard coding

[Gysbert_Wassenaar · Accepted solution]

Open the Expression Overview and use the Find/Replace dialog.

[awhitfield]

Hi prudhvi,

you can use the 'Expression Overview' and use Find/Replace. Just be careful with Upper / Lower case etc.

HTH - Andy

[#5]

depending on requirement, values in filter have to be changed n there r many expresions in many charts.

[#6]

Thanks Andrew