Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

beginnertom
New Contributor III

Display hierarchy dimension in pie chart.

Year.pngMonth.pngHi 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.

 

 

 

 

6 Replies
Partner
Partner

Re: Display hierarchy dimension in pie chart.

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

beginnertom
New Contributor III

Re: Display hierarchy dimension in pie chart.

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. 🙂

 

Partner
Partner

Re: Display hierarchy dimension in pie chart.

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

beginnertom
New Contributor III

Re: Display hierarchy dimension in pie chart.

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!

Partner
Partner

Re: Display hierarchy dimension in pie chart.

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.

Support
Support

Re: Display hierarchy dimension in pie chart.

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

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.