topic How to use aggregation functions on a TreeView hierarchy in QlikView https://community.qlik.com/t5/QlikView/How-to-use-aggregation-functions-on-a-TreeView-hierarchy/m-p/363677#M1174978 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My database has a table of parts that can be composed of other parts. They each have a <STRONG>Price </STRONG>field.</P><P>The <STRONG>Part </STRONG>table also has a <STRONG>Parent_Part</STRONG> field to represent an adjacent nodes tables (The parts hierarchy).</P><P>In the Load Script I use the <EM>hierarchy </EM>function to obtain the <SPAN class="Bold">PathName of each Part </SPAN></P><P><SPAN class="Bold"> </SPAN><SPAN class="Bold">I can then visualise the hierarchy in a TreeView ListBox. (which is awesome by the way)</SPAN></P><P><SPAN class="Bold"> </SPAN></P><P><SPAN class="Bold">I tried to calulate the total cost of a <STRONG>Part </STRONG>(the sum of the cost of the sub parts) by adding the caculated expression : <EM>SUM(Price)</EM></SPAN></P><P><SPAN class="Bold">but I only get the the cost of one part.</SPAN></P><P><SPAN class="Bold"> </SPAN></P><P><SPAN class="Bold">How do you calculate the </SPAN>total cost of a Part?</P><P></P><P>Thanks for your help</P><P></P><P>-Nick</P></BODY></HTML> Tue, 22 May 2012 14:57:26 GMT 2012-05-22T14:57:26Z How to use aggregation functions on a TreeView hierarchy https://community.qlik.com/t5/QlikView/How-to-use-aggregation-functions-on-a-TreeView-hierarchy/m-p/363677#M1174978 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My database has a table of parts that can be composed of other parts. They each have a <STRONG>Price </STRONG>field.</P><P>The <STRONG>Part </STRONG>table also has a <STRONG>Parent_Part</STRONG> field to represent an adjacent nodes tables (The parts hierarchy).</P><P>In the Load Script I use the <EM>hierarchy </EM>function to obtain the <SPAN class="Bold">PathName of each Part </SPAN></P><P><SPAN class="Bold"> </SPAN><SPAN class="Bold">I can then visualise the hierarchy in a TreeView ListBox. (which is awesome by the way)</SPAN></P><P><SPAN class="Bold"> </SPAN></P><P><SPAN class="Bold">I tried to calulate the total cost of a <STRONG>Part </STRONG>(the sum of the cost of the sub parts) by adding the caculated expression : <EM>SUM(Price)</EM></SPAN></P><P><SPAN class="Bold">but I only get the the cost of one part.</SPAN></P><P><SPAN class="Bold"> </SPAN></P><P><SPAN class="Bold">How do you calculate the </SPAN>total cost of a Part?</P><P></P><P>Thanks for your help</P><P></P><P>-Nick</P></BODY></HTML> Tue, 22 May 2012 14:57:26 GMT https://community.qlik.com/t5/QlikView/How-to-use-aggregation-functions-on-a-TreeView-hierarchy/m-p/363677#M1174978 2012-05-22T14:57:26Z How to use aggregation functions on a TreeView hierarchy https://community.qlik.com/t5/QlikView/How-to-use-aggregation-functions-on-a-TreeView-hierarchy/m-p/363678#M1174979 <HTML><HEAD></HEAD><BODY><P>It seems the expression in a TreeView does not behave the same as in charts.<BR />I solved the problem of getting the recursive sum of all the subparts by adding a text Object with the same expression.</P><P>Since clicking on a contracted node of a treeView also selects all the sub nodes, the text object displays the total price of the part!</P></BODY></HTML> Fri, 08 Jun 2012 18:29:43 GMT https://community.qlik.com/t5/QlikView/How-to-use-aggregation-functions-on-a-TreeView-hierarchy/m-p/363678#M1174979 2012-06-08T18:29:43Z