enable a chart on the basis of selection in other chart

[#1]

Hi all

We have a bar chart which has a dimension 'Month'. When we click on the bar of a particular month, every chart and table in the dashboard is filtered for that month and in the bar chart, we get only bar. We want that when clicking on a bar, then another chart should appear and the data for other chart should not get filtered for that month.

Please help us out with this situation.

Thanks in advance

[swuehl]

You can use a show condition on layout tab of chart properties, something like

=GetSelectedCount( MonthField ) = 1

Then use a set expression in your chart expression to ignore the selection in Month, something like

=sum({<MonthField= >}Value)

[MayilVahanan]

HI

Are you looking this?

Edit:

PFA

[#4]

Looks like you want a set analysis to ignore a selection in that chart but you want the chart to pop up only if a selection on month is made.

to ignore selection = http://community.qlik.com/message/117105#117105

to activate the chart only if a selection on month is made you can put a expression like this one in the conditional show.

if(isnull(only(month)),0,1)

[#5]

Hi,

Use, the conditonal Show option under Layout for the chart whcih should show based on selection. Pelase see the attachment.

[#6]

Hi Swuehl

I tried this thing but it isn't working for me. I am trying it in a stacked bar chart and the expression i am using is

=

if([_Month Year]= 'Jan-13',((count({$<[Activity Indication]= {'C'}, [_Month Year]=>}DISTINCT(Physicians))-count({$<[Activity Indication]= {'C'}, [_Month Year]=, [Channel Name]= {'Sales Force'}>}DISTINCT(Physicians)))/vTargetPhysicians)*0.8,
(

if(

[_Month Year]= 'Feb-13',((

count({$<

[Activity Indication]= {'C'},

[_Month Year]=>}

DISTINCT(

Physicians))-

count({$<

[Activity Indication]= {'C'},

[_Month Year]=,

[Channel Name]= {'Sales Force'}>}

DISTINCT(

Physicians)))/

vTargetPhysicians)*0.75,
(

if(

[_Month Year]= 'Apr-13',((

count({$<

[Activity Indication]= {'C'},

[_Month Year]=>}

DISTINCT(

Physicians))-

count({$<

[Activity Indication]= {'C'},

[_Month Year]=,

[Channel Name]= {'Sales Force'}>}

DISTINCT(

Physicians)))/

vTargetPhysicians)*1.1,
(

if(

[_Month Year]= 'May-13',((

count({$<

[Activity Indication]= {'C'},

[_Month Year]=>}

DISTINCT(

Physicians))-

count({$<

[Activity Indication]= {'C'},

[_Month Year]=,

[Channel Name]= {'Sales Force'}>}

DISTINCT(

Physicians)))/

vTargetPhysicians)*1.2,
(

count({$<

[Activity Indication]= {'C'},

[_Month Year]=>}

DISTINCT(

Physicians))-

count({$<

[Activity Indication]= {'C'},

[_Month Year]=,

[Channel Name]= {'Sales Force'}>}

DISTINCT(

Physicians)))/

vTargetPhysicians)))))))

Please tell me what am i doing wrong.