Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
balanandam
Contributor II

Drill down Pie chart

Hi,

I have the chart like below:

Now I wanted Drill down this further like, when I click on any of the Pie, ex: Optimizable I have another 3 sub categories in it. so I should be able to Drill up to that ? Can any one give the idea on how we could achieve this ?

Thanks In advance!

Br, Balanandam

7 Replies
Highlighted
qlik_aparnav
Contributor II

Re: Drill down Pie chart

Create a drill down group and then add that as dimension to pie chart

Highlighted
ajsjoshua
Valued Contributor

Re: Drill down Pie chart

Hi,

In the Dimensions tab of the chart, click Edit Groups. Create a new drill-down group with sub categories then use this as you chart dimension.

Regards,

Joshua.

Highlighted
marferca
New Contributor II

Re: Drill down Pie chart

You can achieve it by using hierarchies. Have a look at Hierarchies

Hope it helps

Highlighted
satheshreddy
Contributor III

Re: Drill down Pie chart

Hi Balanandam,

In dimension tab you can create Edit Groups there you can create group and add that to chart dimension you will get it.

Regards

Sathish

Highlighted
balanandam
Contributor II

Re: Drill down Pie chart

Hi All,

Thanks for your response.

I did now as below:

default view:

  

when I click on Drill down it will be viewed as

Problem is with colors is not showing as expected. I'm using below in Background color option

=only({1}
if(DeviceStatusQlik='Optimized',RGB(0,160,0),
if(DeviceStatusQlik='Pass',RGB(0,128,0),
if(DeviceStatusQlik='Failed',RGB(255,0,0),
if(DeviceStatusQlik='Optimizable',RGB(187,216,84),
if(DeviceStatusQlik='NotTested',RGB(141,170,203),
if(DeviceStatus='Unknown',RGB(141,170,203),
if(DeviceStatus='TF',RGB(255,0,0),
if(DeviceStatus='NTF',RGB(0,128,0))))))))))

only on statement to mention colors for two levels ? is this  correct first ?

Br, Balanandam

Highlighted
balanandam
Contributor II

Re: Drill down Pie chart

First view showing as expected but not second one. Pls. advise.

Highlighted

Re: Drill down Pie chart

Hi Balanandam, maybe adding the option to ignore selections in each field?:

=if(Only({1} DeviceStatusQlik)='Optimized',RGB(0,160,0),
if(Only {1} DeviceStatusQlik)='Pass',RGB(0,128,0),

...