How to activate/show an object(Pie-chart) when we select the dimension in Barchart/Pivot Table

[PradeepReddy]

Hi,

Here is the requirement. whenver  I click a dimension in Bar Chart/Pivot table, another chart(Pie chart) should be populated. This shouldbe dynamic.

Org Type	Sector	Company Name	Tax pay
Govt	Biotechnology	Name1
	Infrastructure	Name2
	Medical	Name3
	Manufacturing	Name4
Private	IT	Name5
	Manufacturing	Name6
	Banking	Name7
Public-Private	Biotechnology	Name8
	Infrastructure	Name9
	Medical	Name10
	Manufacturing	Name11

Suppose when I selected the dimension 'Org Type' in pivot table/bar chart, a new sheet object(Pie chart) with "Sector" as dimension & "Tax pay" as expression shoud be visible.

Thanks in advance...

[jonathandienst]

Hi

Populating the pie chart when a selection is made is standard QV functionality. If you want to hide the pie chart until something is selected, use a Show condition in Properties | Layout of the pie chart. Use something like

     =If(GetSelectedCount([Org Type]) >= 1, 1, 0)

for the condition.

HTH

Jonathan

[Anonymous]

You should use circular or drill down dimensions.  So that when you click on a section of a pie chart or a bar in a bar chart it will drill down to the next level or show any different dimension you want. You can define them in the dimension tab

[PradeepReddy]

Thanks Jonathan for the quick reply..

But the the is I have one list box "Org Type". So whenever I selects the value from the list box also the pie chart will be populated... actually that is not the the  scenario. ( The pie chart should be populated only when we choose the dimension in bar chart only).

[PradeepReddy]

Thanks  Adrian..

This approach will work for barchart/pie chart type in some extenent....If we have the data in pivot table then how we can achieve this scenario?

[Anonymous]

You can also allow the chart to switch between different types (Fast Type Change) on the general tab.  It allows the same information to be shown as any of the charts

[PradeepReddy]

in this way, we can show case same data in different objects,  I think it won't catter my requirement.

[PradeepReddy]

Anythoughts from all of you.. it is a liitle bit urgent requirement for me...

[jonathandienst]

Pradeep Taniparthy wrote:

But the the is I have one list box "Org Type". So whenever I selects the value from the list box also the pie chart will be populated... actually that is not the the  scenario. ( The pie chart should be populated only when we choose the dimension in bar chart only).

I don't think there is any way to detect how the Org Type was selected. Clicking in the bar chart is functionally the same as selecting one in the list box.

If you don't want the users to make selections in the list box, don't include the list box on the sheet (although I don't know why you would want to do that)

HTH

Jonathan

[PradeepReddy]

Actually,  I am showcasing summary information in bar/pie chart. Whenever I click on the chart I have to populate the detailed inforamtion in table(Pivot/Straight/General Table) format....