topic Re: Drill down Pie chart in QlikView

Drill down Pie chart

balanandam — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Drill down Pie chart

Anonymous — Mon, 08 Jan 2018 07:17:36 GMT

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

Re: Drill down Pie chart

ajsjoshua — Mon, 08 Jan 2018 07:21:43 GMT

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.

Re: Drill down Pie chart

Anonymous — Mon, 08 Jan 2018 07:23:50 GMT

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

Hope it helps

Re: Drill down Pie chart

satheshreddy — Mon, 08 Jan 2018 07:27:48 GMT

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

Re: Drill down Pie chart

balanandam — Mon, 08 Jan 2018 10:15:55 GMT

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

Re: Drill down Pie chart

balanandam — Mon, 08 Jan 2018 10:53:58 GMT

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

Re: Drill down Pie chart

rubenmarin — Mon, 08 Jan 2018 11:25:56 GMT

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),

...