topic Re: How to drill down in Pie Chart without using Drill Down Function in QlikView

How to drill down in Pie Chart without using Drill Down Function

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

How can i drill down in Pie Chart without using Drill Down Function in qlikview????

Lets Say i have three Dimensions ={Country, State,City}

and Measure as Sales Now i want drill down

Country------> State----->City

Note: Here i don't want to use Drill Down Dimension

abhijith862 — Tue, 06 Feb 2018 09:58:07 GMT

Hi,

Here you will need three pie charts for all three dimensions:

City as Bottom Layer in Layout

State as Normal Layer in Layout

Country as Top Layer in Layout

Now in the Country Dimension select Condition from Show in Layout and enter this expression "GetCurrentSelections(Country)=Country"

and in State Dimension select Condition from Show in Layout and enter this expression "GetCurrentSelections(States)>States"

and then overlap the charts starting from City in the bottom and then State and Country in the top.

kundan_sharma1 — Tue, 06 Feb 2018 10:01:19 GMT

Thanks,

It works