Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Drill down with differents charts

Hello everybody!!!

I am trying to make a chart using drill down. I would like to use different kind of charts. 

Can we do that???

I am using Qlikview Personal Edition.

Labels (1)
1 Solution

Accepted Solutions
vamsee
Specialist
Specialist

I assume you are looking for a combination of Drill Down and Fast Change properties of Qlikview. It's not possible directly, as a workaround you could hide and display charts based on user selections.

  1. Create a chart with drill down the group as the dimension.
    1. Field1
    2. Field2
  2. Clone the chart twice
  3. In the first chart go to the layout tab, under show conditional 
    1. IF(GetSelectedCount(Field1)=0 and GetSelectedCount(Field2)=0,1,0)
  4. In the second chart go change the chart type under general tab, in the layout tab, under show conditional 
    1. IF(GetSelectedCount(Field1)=1 and GetSelectedCount(Field2)=0,1,0)
  5. On the third chart, change the chart type under general tab, in the go to the layout tab, under show conditional 
    1. IF(GetSelectedCount(Field1)=1 and GetSelectedCount(Field2)=1,1,0)

 

Finally, 3 charts are created with the same dimension and expression, but the charts are only displayed based on user selections. 

 

P.s: Make sure all the three charts are exactly in the same place, i.e. on top of each other.

 

 

 

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/FastTypeChan...

 

 

View solution in original post

3 Replies
vamsee
Specialist
Specialist

Drill downs are possible in multiple charts.

Can you explain what exactly are you looking for?

http://livingqlikview.com/livingqlik-roots-how-to-create-cyclic-and-drill-down-grouped-dimensions/

 

Anonymous
Not applicable
Author

For example, I have a pie chart, if I click on a part of the chart, I want to you show a bar char as drill down. And the next chart will be a simple table.

This is the example that I want to do.

vamsee
Specialist
Specialist

I assume you are looking for a combination of Drill Down and Fast Change properties of Qlikview. It's not possible directly, as a workaround you could hide and display charts based on user selections.

  1. Create a chart with drill down the group as the dimension.
    1. Field1
    2. Field2
  2. Clone the chart twice
  3. In the first chart go to the layout tab, under show conditional 
    1. IF(GetSelectedCount(Field1)=0 and GetSelectedCount(Field2)=0,1,0)
  4. In the second chart go change the chart type under general tab, in the layout tab, under show conditional 
    1. IF(GetSelectedCount(Field1)=1 and GetSelectedCount(Field2)=0,1,0)
  5. On the third chart, change the chart type under general tab, in the go to the layout tab, under show conditional 
    1. IF(GetSelectedCount(Field1)=1 and GetSelectedCount(Field2)=1,1,0)

 

Finally, 3 charts are created with the same dimension and expression, but the charts are only displayed based on user selections. 

 

P.s: Make sure all the three charts are exactly in the same place, i.e. on top of each other.

 

 

 

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/FastTypeChan...