Quetion in alternate state in doccument settings

[#1]

Hello,

I got a doubt. I'm Having 3 filters(List boxes) Brand, Country and Segment. and I'm having 4 charts in the dashboard. I want the first two filters for all 4 charts let the first 2 filters be global filters  and 3rd filter (Segment) for only 2 of the 4 charts. I tried alternate state options from document settings but it is not working out. I cannot make global filters for all 4 charts. Is it any way to give multiple alternate state to a single chart?

[alexandros17]

Good idea,alternate states work but you must use a filter (with its alternate state) working on a table with the same alternate state and you have to insert in the filter all the fields you need, a filter cannot be simoultaneously global and local...

[#3]

you cannot assign multiple alternate states in document settings, rather you can do that using setanalyiss.

Lets say you create 2 alternate states Alt1 for filter3 and Alt2 for filter4 then the expression should be like below.

sum({<filter3=[Alt1]::filter3>}Sales

sum({<filter4=[Alt2]::filter4>}Sales

[#4]

Yes Ok Shruthi I will try it out

[#5]

Hi

you can try show conditional property in list box

[#6]

No not in list box I want to give multiple filters(i.e. Alternate states) to single chart

[#7]

Shruthi where do we have to give the condition? in alternate states?

[sasikanth · Accepted solution]

HI durga Prasad You  can achieve this using set analysis

like below

In those 2 charts which you dont want change when segement is selected

Write the Expression like

E.g :

=sum({<Segment=>}sales)

then the charts will respond if you made any selections on Segment

[#9]

Hello Sasikanth

Where do I have to write the expression? in layout of the chart?

[sasikanth]

You have to write the same thing in your expression in those two charts