topic Re: Display hierarchy dimension in pie chart. in QlikView

Display hierarchy dimension in pie chart.

beginnertom — Sat, 16 Nov 2024 20:24:59 GMT

Hi Everyone,

I am looking for a solution to display dimension in pie charts, i read a lot of post in forum, generally, they suggest using a new expression to display the dimension, but the expression only can state in one dimension, but refer to my sample file, i create a hierarchy groups by year and month, if I use below solution, once i click the pie chart 2018 side, it will go to Month level, but the dimension shown in the pie chart, will still appear as 2018 in month level.

https://community.qlik.com/t5/New-to-QlikView/Dimension-as-label-in-pie-chart/m-p/738411

https://community.qlik.com/t5/New-to-QlikView/Display-Dimension-Labels-in-Pie-Chart/td-p/1105146

How can I display the hierarchy group dimension in the pie chart?

Thanks to everyone who can answer my question.

Re: Display hierarchy dimension in pie chart.

hallquist_nate — Mon, 22 Jul 2019 15:15:39 GMT

Have you tried using a Cycle Group? You may have to do some data work, but that should work. You will need to create a Year field and a month field. I recommend that you do this in a Master Calendar. Then, create a new Group, make it a cycle group, and add Year and then add Month.

You can change the dimension of the chart from the Year to Month, and back again, without selecting a Year, like you have in your Hierarchy group.

Good Luck,

Nate

Re: Display hierarchy dimension in pie chart.

beginnertom — Tue, 23 Jul 2019 14:57:06 GMT

Hi Nate,

thanks for your reply, you mean using cycle group will different compare with drill-down group?

But i change the dimension to cycle group didn't find a way to show the hierarchy dimension inside the pie chart segments.

Would you mind to modify my qvw to show me the method you suggest?

Since I am new for qlikview, you mean mastercalendar can help me to label the dimension inside the pie chart segments?

Thanks for all your kindly help. 🙂

Re: Display hierarchy dimension in pie chart.

hallquist_nate — Tue, 23 Jul 2019 15:51:02 GMT

If you absolutely have to show the hierarchy in your data Viz, then you can simply add the needed dimensions to the Pie chart, which I have done. It looks awful, not going to lie. However, a Tree Map is better suited for the task of displaying a hierarchy, within proportions/shares. I have added an example to the Solution file and attached it.

Cycle groups allow you to change a dimension within an object. it doesn't have to be hierarchical. Drill-down groups allow you to dynamically navigate a hierarchy by using selections. Both have their place, but it is important to understand the functionality. In this case, I don't know that forcing a hierarchy into a Pie chart is a good move. Take a look at the Tree Map. It is best suited for this use case.

Nate

Re: Display hierarchy dimension in pie chart.

beginnertom — Sat, 27 Jul 2019 14:32:56 GMT

Hi Nate,

i read your solution, but my question is to display the dimension inside the pie chart segments according to my hierarchy dimensions.

For example, I create a group like a year and month which call time group, if the dimension now is a year, it shows the year like 2019/2018 inside the pie chart segments.

If I click one year, the pie chart will go down to month level and the dimension will now display month but not month.

Thanks!

Re: Display hierarchy dimension in pie chart.

hallquist_nate — Mon, 29 Jul 2019 14:18:39 GMT

I'm not sure you can get the Pie chart to perform exactly like you want it to. I think the Tree Map is designed for this purpose and will fit the need well.

Re: Display hierarchy dimension in pie chart.

Brett_Bleess — Wed, 14 Aug 2019 16:44:56 GMT

Try the following Design Blog post, not sure if it helps or not, but it is worth a read I think...

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Regards,
Brett