topic Re: Drill down with differents charts in QlikView

Drill down with differents charts

Anonymous — Sat, 16 Nov 2024 21:53:34 GMT

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.

Re: Drill down with differents charts

vamsee — Wed, 14 Nov 2018 19:39:48 GMT

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/

Re: Drill down with differents charts

Anonymous — Thu, 15 Nov 2018 22:29:23 GMT

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.

Re: Drill down with differents charts

vamsee — Mon, 19 Nov 2018 16:46:51 GMT

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.

Create a chart with drill down the group as the dimension.
1. Field1
2. Field2
Clone the chart twice
In the first chart go to the layout tab, under show conditional
1. IF(GetSelectedCount(Field1)=0 and GetSelectedCount(Field2)=0,1,0)
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)
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/FastTypeChange.htm