list box for only one chart

[Anonymous]

Hello,

I have one sheet with 4 charts and 3 objects. i have 4 list boxes.my requirement is 3 list box selections should effect all the objects and charts when i give selection in 4th list box that should be effected only one particular chart with keeping previous list box selections.

Thanks,

Venkat.

[sujeetsingh]

You can use the set analysis to ignore the selection of this 4th field in the expression of the chart you want where there should be no selection.

If you have Brand you do not want the Brand filter selection to to an expressions

sum({<Brand=->}Slaes)

[kulasekhar]

Hi Venkat,

May be like this? PFA,

Thanks,

Sekkhar

[Anonymous]

i cant open qvw file coz i am using personal editor

[#5]

You can make use of Alternate States.

1. Create a new State (Doc Props -- General -- Alternate States)

2. Use this newly created state only for the two objects you want to be unaffected by any selections. Object Props -- General -- Alternate State. This field is visible only when a user created Alternate State exists in the document.

Please see attached screenshots for better understanding.

[Anonymous]

if we do like that other list box selection wont effect final chart right...coz chart state is different from others list boxs...

[#7]

yes, that is what you wanted. The chart should be affected only by the 4th list box?

[Anonymous]

thats not my requirment..my final chart shld effected by all list box selections......4th list box selection shld nt effect other object except my final chart....

[#9]

ok..then use Set Analysis in the chart expression and ignore the field used in this 4th list box.