Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Chart

Hi,

I have a Pie chart where it shows sales of different countries .

If i click on one country then it has to show me the sales of different cities of that particular country but in Bar chart and at the same time the pie chart(original chart it self) should show me the month sales(each moth how much sales do the country have ) .After that when i clear the selection the bar chart has to go so that again i can select another country . What can i do in this case? Please suggest

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Chart

Create a drilldown group for your pie chart with Country and Months. Add the group as dimension to your pie chart. Add a bar chart with Cities as dimension. See attached example which uses Region, Months and Products, but the principle is the same. If you don't want to show the bar chart when no country is selected add an expression to the Show condition on the Presentation tab: if(getselectedcount(Country),1,0)


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Chart

Create a drilldown group for your pie chart with Country and Months. Add the group as dimension to your pie chart. Add a bar chart with Cities as dimension. See attached example which uses Region, Months and Products, but the principle is the same. If you don't want to show the bar chart when no country is selected add an expression to the Show condition on the Presentation tab: if(getselectedcount(Country),1,0)


talk is cheap, supply exceeds demand
er_mohit
Honored Contributor II

Re: Chart

for this purpose edit group as drop down in your dimension of chart and choose month field or country or city as per your request

hope it will helps you

for this edit group going to chart properties in dimension add at last on left side edit there you can add the dimensions