topic Re: Displaying values below selected level in hierarchy in QlikView

Displaying values below selected level in hierarchy

Wed, 09 Oct 2013 11:57:12 GMT

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.

Re: Displaying values below selected level in hierarchy

saumyashah90 — Wed, 09 Oct 2013 12:07:31 GMT

Hope this helps you

Re: Displaying values below selected level in hierarchy

Gysbert_Wassenaar — Wed, 09 Oct 2013 12:13:30 GMT

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

Re: Displaying values below selected level in hierarchy

israrkhan — Wed, 09 Oct 2013 12:16:13 GMT

have you tried calculated dimension.

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

Re: Displaying values below selected level in hierarchy

Wed, 09 Oct 2013 12:20:44 GMT

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.

Re: Displaying values below selected level in hierarchy

amitarusi — Wed, 09 Oct 2013 12:25:59 GMT

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

put the group as the dimension in the chart.

Re: Re: Displaying values below selected level in hierarchy

saumyashah90 — Wed, 09 Oct 2013 12:30:29 GMT

Please check this for your exact requirement

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

Re: Displaying values below selected level in hierarchy

Wed, 09 Oct 2013 12:47:49 GMT

Thanks for your help everyone. Have it working now.