topic Re: Selections should not work on other chart in QlikView

Selections should not work on other chart

anat — Wed, 07 Jan 2015 09:42:01 GMT

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.

Re: Selections should not work on other chart

Wed, 07 Jan 2015 09:44:48 GMT

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

Re: Selections should not work on other chart

anat — Wed, 07 Jan 2015 09:56:56 GMT

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=>}.

Re: Selections should not work on other chart

alkesh_sharma — Wed, 07 Jan 2015 09:58:43 GMT

Send you expression and the fields you want to bypass.

Re: Selections should not work on other chart

alexandros17 — Wed, 07 Jan 2015 10:05:04 GMT

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.

Re: Selections should not work on other chart

agomes1971 — Wed, 07 Jan 2015 10:13:24 GMT

Hi,

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

Regards

André Gomes

Re: Selections should not work on other chart

anat — Wed, 07 Jan 2015 10:29:27 GMT

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

Re: Selections should not work on other chart

anat — Wed, 07 Jan 2015 10:36:04 GMT

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

Re: Selections should not work on other chart

Wed, 07 Jan 2015 10:36:14 GMT

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

Re: Selections should not work on other chart

alkesh_sharma — Wed, 07 Jan 2015 10:48:40 GMT

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.