Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
PradeepReddy
Specialist II
Specialist II

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

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 TypeSectorCompany NameTax pay
GovtBiotechnologyName1
InfrastructureName2
MedicalName3
ManufacturingName4
PrivateITName5
ManufacturingName6
BankingName7
Public-PrivateBiotechnologyName8
InfrastructureName9
MedicalName10
ManufacturingName11

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

12 Replies
Anonymous
Not applicable

Hi Jonathan

Thanks for the Suggestion it really works

But

I have a new Scenario that

like

Year,

Month,

day

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

is it Possible ?

Regards

Tahemas

Kushal_Chawda

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

Shubham_Deshmukh
Specialist
Specialist

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