topic Re: Bar Chart - Drilled down of specific field in QlikView

Bar Chart - Drilled down of specific field

Fri, 28 Sep 2012 11:52:00 GMT

Hi,

I was wondering if someone knew this answer to this query.

I have 2 fields, one called Level3desc and another called Level4desc. These fields show the software and subsoftware of a call that is raised on our helpdesk. Therefore Level3desc may show Microsoft Office and Level4desc may show Word 2010.

What I want to achieve on my bar chart, is that if I click the Microsoft Office part of the bar chart (which may show 50) calls, I want it to be able to drill down into the subsoftware categories (therefore another bar chart occurs in place of the existing one possibly showing: Word 2010 25 calls, excel 2010 10 calls, access 2003 5 calls, other 10 calls)

Is this Possible.

Regards,

Jon Ditchfield

Re: Bar Chart - Drilled down of specific field

Jason_Michaelides — Fri, 28 Sep 2012 11:58:18 GMT

No need for another bar chart. In the Dimensions tab of the chart, click Edit Groups. Create a new drill-down group with Level3desc and Level4desc then use this as you chart dimension.

Hope this helps,

Jason

Re: Bar Chart - Drilled down of specific field

Fri, 28 Sep 2012 13:00:03 GMT

Thanks for your help Jason