topic Create hierarchy chart in App Development https://community.qlik.com/t5/App-Development/Create-hierarchy-chart/m-p/809822#M11199 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have hierarchy variable:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">Europe</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">Africa</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">Asia</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Europe#England</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Europe#England#London</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Europe#England#Manchester</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Europe#England#</EM>Liverpool</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Africa#Egypt</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Africa#Egypt#Cairo</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><EM style="font-weight: inherit; font-size: 13.3333320617676px; font-family: inherit;">Asia#China</EM></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;">I want to create a pie chart that contains the first child (for ex. England - 4, Egypt - 2 and China - 1)</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;">something like this:</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><IMG alt="table.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79512_table.png" style="height: auto;" /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;">How can i do that?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;">Thank you!</SPAN></P></BODY></HTML> Sun, 01 Mar 2015 08:35:20 GMT 2015-03-01T08:35:20Z Create hierarchy chart https://community.qlik.com/t5/App-Development/Create-hierarchy-chart/m-p/809822#M11199 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have hierarchy variable:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">Europe</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">Africa</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">Asia</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Europe#England</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Europe#England#London</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Europe#England#Manchester</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Europe#England#</EM>Liverpool</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Africa#Egypt</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333330154419px; font-family: inherit;">Africa#Egypt#Cairo</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><EM style="font-weight: inherit; font-size: 13.3333320617676px; font-family: inherit;">Asia#China</EM></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;">I want to create a pie chart that contains the first child (for ex. England - 4, Egypt - 2 and China - 1)</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;">something like this:</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><IMG alt="table.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79512_table.png" style="height: auto;" /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;">How can i do that?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;">Thank you!</SPAN></P></BODY></HTML> Sun, 01 Mar 2015 08:35:20 GMT https://community.qlik.com/t5/App-Development/Create-hierarchy-chart/m-p/809822#M11199 2015-03-01T08:35:20Z Re: Create hierarchy chart https://community.qlik.com/t5/App-Development/Create-hierarchy-chart/m-p/809823#M11200 <HTML><HEAD></HEAD><BODY><P>Use Calculated Dimension</P><P></P><P><IMG __jive_id="79516" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79516_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Then Expression</P><P>=COUNT(TextBetween(data&amp;'#','#','#'))</P><P></P><P><IMG __jive_id="79518" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/79518_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Script :</P><P>load * inline</P><P>[</P><P>data</P><P>Europe</P><P>Africa</P><P>Asia</P><P>Europe#England</P><P>Europe#England#London</P><P>Europe#England#Manchester</P><P>Europe#England#Liverpool</P><P>Africa#Egypt</P><P>Africa#Egypt#Cairo</P><P>Asia#China</P><P>]</P></BODY></HTML> Sun, 01 Mar 2015 09:45:33 GMT https://community.qlik.com/t5/App-Development/Create-hierarchy-chart/m-p/809823#M11200 robert_mika 2015-03-01T09:45:33Z Re: Create hierarchy chart https://community.qlik.com/t5/App-Development/Create-hierarchy-chart/m-p/809824#M11201 <HTML><HEAD></HEAD><BODY><P>Thanks a lot! It was very helpful.</P></BODY></HTML> Sun, 01 Mar 2015 13:28:46 GMT https://community.qlik.com/t5/App-Development/Create-hierarchy-chart/m-p/809824#M11201 2015-03-01T13:28:46Z Re: Create hierarchy chart https://community.qlik.com/t5/App-Development/Create-hierarchy-chart/m-p/809825#M11202 <HTML><HEAD></HEAD><BODY><P>You are welcome.</P><P>Thanks for feedback</P></BODY></HTML> Sun, 01 Mar 2015 16:15:49 GMT https://community.qlik.com/t5/App-Development/Create-hierarchy-chart/m-p/809825#M11202 robert_mika 2015-03-01T16:15:49Z