Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kundan_sharma1
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
abhijith862
Contributor III
Contributor III

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.

View solution in original post

2 Replies
abhijith862
Contributor III
Contributor III

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
Contributor III
Contributor III
Author

Thanks,

It works