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

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

PradeepReddy — Mon, 27 Jan 2014 11:17:17 GMT

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

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

jonathandienst — Mon, 27 Jan 2014 11:29:50 GMT

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

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

Anonymous — Mon, 27 Jan 2014 11:39:49 GMT

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

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

PradeepReddy — Mon, 27 Jan 2014 11:45:52 GMT

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).

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

PradeepReddy — Mon, 27 Jan 2014 11:48:55 GMT

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?

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

Anonymous — Mon, 27 Jan 2014 11:51:36 GMT

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

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

PradeepReddy — Mon, 27 Jan 2014 11:55:01 GMT

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

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

PradeepReddy — Tue, 28 Jan 2014 13:59:42 GMT

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

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

jonathandienst — Tue, 28 Jan 2014 14:10:30 GMT

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

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

PradeepReddy — Wed, 29 Jan 2014 04:17:19 GMT

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

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

Anonymous — Fri, 29 Sep 2017 06:47:48 GMT

Hi Jonathan

Thanks for the Suggestion it really works

But

I have a new Scenario that

Year,

Month,

day

So when i select any Value from month then it should not effect to Year

is it Possible ?

Regards

Tahemas

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

Kushal_Chawda — Fri, 29 Sep 2017 08:02:59 GMT

to get this done, create the copy of your dimension based on which you need to show pie chart

LOAD ...

[Org Type],

[Org Type] as [Org Type Bar],

[Org Type] as [Org Type Pivot],

Use [Org Type] in listbox which will be standard for all

Use [Org Type Bar] dimension in Bar chart

Use [Org Type Pivot] dimension in Pivot table

Now, in pie chart->Properties->Layout->Conditional, put below expression

=getselectedcount([Org Type Bar])>0 or getselectedcount([Org Type Bar])>0

or you can create only one copy of your dimension, which can be used in Bar/Pivot Both

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

Shubham_Deshmukh — Tue, 01 Jan 2019 15:18:25 GMT

Hey,
I just want to clear one thing that we cannot activate any chart by selecting Bar chart , right?