Avoiding list box selection in chart

[Anonymous]

Hi folks,

I want to make one chart unresponsive for one perticular list box selection...... selections of listbox should not effect chart..

Thanks in Advance...

Regards,

Venkat.

[sorrakis01]

Hi,

On Properties of chart (General Sheet) you have a property to unlink the chart.

Or other option (if you need the listbox) is in expressions you can use set analysis for it.

Regards,

[nagaiank · Accepted solution]

If the list box is for a dimension Field1, include in the expression of the chart the following set expression

{<Field1=>}

[#4]

Hi,

Try to create a alternate state in document properties and place in chart general properties,

or else whatever list box you are using just exclude that list box field in chart expression

suppose you have Country list box

in chart you have sum(sales)

just write exoression like this sum({<countrty=>} sales)

[#5]

Hi,

Use Alternate States option to do this. Please check 11 developers guide for Alternate State.

Thank you.

Regards,

Srinivasu

[ashfaq_haseeb]

Hi,

Go for Alternate states.

Regards

ASHFAQ

[Kushal_Chawda]

Create a chart with Expression as

Sum({<Field1 =, Field2=>} Sales)

Selections from Field1 & Field2 will not affect the chart using above expression

[Anonymous]

Thanks Nag...

i hav this expr..

Sum({$<TerritoryGroup={Europe} >}Sales)/Sum(Sales)

and i hav list box for TerritoryGroup...when i select values in that my stacked bar chart showing >100%..... i hav 3 values in TG...Europe, NorthAmerica and Pacific....