topic Re: Re: Set analysis to stop drill down in Pie Chart in QlikView

Set analysis to stop drill down in Pie Chart

Wed, 09 Apr 2014 12:56:49 GMT

HI,

I have a pie chart with drill down option, in dimension (grouped) --> Geography-->Region, showing value of sales

When I drill down to Region the Pie should not allow me to further drill to single Region where Pie shows 100% for a single region. Rather it should start from Geo to region and stop at Region showing split % all regions of particular Geo.

Please let me know how set analysis can be used.

Thanks,

Chanchal

Re: Set analysis to stop drill down in Pie Chart

arjunkrishnan — Wed, 09 Apr 2014 13:02:01 GMT

Pls Attach Your Qvw

Re: Set analysis to stop drill down in Pie Chart

yduval75 — Wed, 09 Apr 2014 13:03:39 GMT

You can try :

if(getcurrentfield([hierarchicgroupname])='Region', Sum({<Region=>} Sales)

Re: Set analysis to stop drill down in Pie Chart

lironbaram — Wed, 09 Apr 2014 13:06:16 GMT

just use

sum({<Region=>}Sales)

this set analysis ignores selections made in the region field

how ever you should note the clicking on the chart will select a single region ,

so all other object will show other data then the pie chart

Re: Set analysis to stop drill down in Pie Chart

Thu, 10 Apr 2014 10:45:30 GMT

Please find the qv file attached, if you select Geo its flows to region and when you select region the selected region flows and pie shows as 100% for that selected region. I want that my selection should stop at at region & should not flow to particular region.

Re: Re: Set analysis to stop drill down in Pie Chart

lironbaram — Thu, 10 Apr 2014 13:41:19 GMT

have a look at the attach qv

Re: Set analysis to stop drill down in Pie Chart

Fri, 11 Apr 2014 12:20:25 GMT

Thanks Liron. Its helpful!!!