topic Hierarchical Sum in QlikView https://community.qlik.com/t5/QlikView/Hierarchical-Sum/m-p/961077#M970847 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P></P><P>I want to create a pivot table in which i need to show a hierarchy and their sum. i have tow different tables one have device information and other one is for hierarchy like below.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Device</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Level</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Qty</STRONG></TH></TR><TR><TD style="padding: 2px;">DvcA</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">6</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB1</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">25</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB1</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">55</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB2</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">36</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB2</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">59</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC1</SPAN></TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">110</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC2</SPAN></TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">115</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC3</SPAN></TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">210</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC4</SPAN></TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">266</TD></TR></TBODY></TABLE><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level3</STRONG></TH></TR><TR><TD style="padding: 2px;">DvcA</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB1</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC1</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB1</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC2</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB2</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC3</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB2</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC4</SPAN></TD></TR></TBODY></TABLE><P>And i want my result like this </P><P></P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 798px; height: 99px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level1Sum</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Level2</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level2Sum</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Level3</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Levle3Sum</TH></TR><TR><TD style="padding: 2px;">DvcA</TD><TD style="padding: 2px;">24</TD><TD style="padding: 2px;">DvcB1</TD><TD style="padding: 2px;">80</TD><TD style="padding: 2px;">DvcC1</TD><TD style="padding: 2px;">110</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">DvcC2</TD><TD style="padding: 2px;">115</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB2</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">95</SPAN></TD><TD style="padding: 2px;">DvcC3</TD><TD style="padding: 2px;">210</TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD>DvcC4</TD><TD>266</TD></TR></TBODY></TABLE><P>Please guide anyone to achieve this.</P></BODY></HTML> Wed, 16 Sep 2015 10:12:35 GMT 2015-09-16T10:12:35Z Hierarchical Sum https://community.qlik.com/t5/QlikView/Hierarchical-Sum/m-p/961077#M970847 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P></P><P>I want to create a pivot table in which i need to show a hierarchy and their sum. i have tow different tables one have device information and other one is for hierarchy like below.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Device</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Level</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Qty</STRONG></TH></TR><TR><TD style="padding: 2px;">DvcA</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">6</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB1</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">25</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB1</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">55</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB2</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">36</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB2</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">59</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC1</SPAN></TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">110</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC2</SPAN></TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">115</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC3</SPAN></TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">210</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC4</SPAN></TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">266</TD></TR></TBODY></TABLE><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level3</STRONG></TH></TR><TR><TD style="padding: 2px;">DvcA</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB1</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC1</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB1</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC2</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB2</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC3</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcA</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB2</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcC4</SPAN></TD></TR></TBODY></TABLE><P>And i want my result like this </P><P></P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 798px; height: 99px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level1Sum</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Level2</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level2Sum</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Level3</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Levle3Sum</TH></TR><TR><TD style="padding: 2px;">DvcA</TD><TD style="padding: 2px;">24</TD><TD style="padding: 2px;">DvcB1</TD><TD style="padding: 2px;">80</TD><TD style="padding: 2px;">DvcC1</TD><TD style="padding: 2px;">110</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">DvcC2</TD><TD style="padding: 2px;">115</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">DvcB2</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">95</SPAN></TD><TD style="padding: 2px;">DvcC3</TD><TD style="padding: 2px;">210</TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD>DvcC4</TD><TD>266</TD></TR></TBODY></TABLE><P>Please guide anyone to achieve this.</P></BODY></HTML> Wed, 16 Sep 2015 10:12:35 GMT https://community.qlik.com/t5/QlikView/Hierarchical-Sum/m-p/961077#M970847 2015-09-16T10:12:35Z Re: Hierarchical Sum https://community.qlik.com/t5/QlikView/Hierarchical-Sum/m-p/961078#M970848 <HTML><HEAD></HEAD><BODY><P>any update</P></BODY></HTML> Thu, 17 Sep 2015 04:11:32 GMT https://community.qlik.com/t5/QlikView/Hierarchical-Sum/m-p/961078#M970848 2015-09-17T04:11:32Z