Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?