QlikView App Dev

[kundan_sharma1]

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 · Accepted solution]

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]

Thanks,

It works