Selections should not work on other chart

[anat]

Hi Team,

sheet1 i have year and month list boxes for selection purpose and 2 charts(Grid chart ,bar chart).

my requirement is if i make any selection on  Grid chart   those selections should not impact on bar  chart .

without using alternate states.

[#2]

Hi bab,

have a look at using set analysis within your bar chart, you can have selections from certain fields not affect the expression.

example your expression in the bar might be Sum(Sales), adjust this to Sum({<year=,month=>} Sales) would ignore any selections on those two fields

have a look at http://community.qlik.com/docs/DOC-4951

for more info on set analysis

hope that helps

Joe

[anat]

Thanks for your response,here the  problem is in Grid chart we have multiple dims ( drill down groups like country.....state....location....d1...d2.....d3....) and the expression is very complex(multiple set analysis)not possible to implement like this {<year=,month=>}.

[alkesh_sharma]

Send you expression and the fields you want to bypass.

[alexandros17]

The set analysis tip is the best one but you could copy your charts (the ones you do not want to be changed by selections) in another sheet then when you go to this new sheet you can easily delete all the selections with a trigger.

[agomes1971]

Hi,

never forget that this is hard to maintain because you should inform users which graphs do not change with selections...

Regards

André Gomes

[anat]

Actually in dashboard we implemented these 2 charts for Analysis purpose ,any alternative ?

[anat]

any possibility like: if(active object id='CH01','detatch','Active')

[#9]

What is the expression for the bar chart and full list of dims you need to ignore? Should be possible to add into it

[alkesh_sharma]

NO, Either you achieve it by Alternate state or Set analysis.

Share your expression and list of files. it would be that difficult to implement in the expression.