Displaying values below selected level in hierarchy

[#1]

Hi,

I'm new to Qlikview, so apologies if this is an obviously easy question.

I've created a geographical hierarchy (Global-->Continent-->Country-->City-->Product) using the Hierarchy and HierarchyBelongsTo functions. Everything is working fine there - when I select the right level of the tree I can see the total amount of sales for all levels below that.

I'm now trying to create a Pie Chart that shows the totals for the levels BELOW the selected level in the hierarchy. For example, if I select 'Global', I want the pie chart to show 5 slices, one for each of the continents. Select a continent, and the pie chart should show a slice for each country within that continent.

I'm not having any luck with this as yet. Can someone give me any pointers?

Thanks,

Rory.

[saumyashah90]

Hope this helps you

[Gysbert_Wassenaar]

Perhaps you can use a drill-down group for this. You can create groups on the Groups tab of the document properties window.

[israrkhan]

have you tried calculated dimension.

like if(GetSelectedCount(Global)<>0,Continent, if GetSelectedCount(Continent)<>0, Country, another if)

[#5]

Hi Saumya,

That's close to what I'm looking for. However, what I really want is for the pie chart to only display the level below that one selected. So in your example, if I select City, then the pie chart should show segments for Fan and Radio only. If I select Sri Lanka, then the pie would show just one segment for Colombo.#

Does that make sense?

Thanks,

Rory.

[amitarusi]

try to create a drill down group with the right levels.

put the group as the dimension in the chart.

[saumyashah90 · Accepted solution]

Please check this for your exact requirement

click inside the pie chart on one country will show you city details then product

[#8]

Thanks for your help everyone. Have it working now.