topic Hierarchy & Sub Total from Linear Data in QlikView https://community.qlik.com/t5/QlikView/Hierarchy-Sub-Total-from-Linear-Data/m-p/446575#M166609 <HTML><HEAD></HEAD><BODY><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="224" style="border: 1px solid rgb(0, 0, 0); width: 384px; height: 211px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Location</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD><P>Asia</P></TD><TD>10</TD></TR><TR><TD>Sri Lanka</TD><TD>1</TD></TR><TR><TD>China</TD><TD>2</TD></TR><TR><TD>Japan</TD><TD>3</TD></TR><TR><TD>Europe</TD><TD>7</TD></TR><TR><TD>Paris</TD><TD>1</TD></TR><TR><TD>Germany</TD><TD>4</TD></TR><TR><TD>Sweden</TD><TD>5</TD></TR><TR><TD>Denmark</TD><TD>1</TD></TR></TBODY></TABLE><P>I would like to represent the aboe in a pivot table with 1st column as </P><P>Continent having Values Asia &amp; Europe and 2nd column as sri Lanka,China,Japan for Asia</P><P>&amp; Paris,Germany,Sweden,Denmark for Europe</P><P>The value in each cell for the Coutry should show the values as above while the Sub Total for Asia shud be 10 &amp; for Europe shud b 7.</P><P><BR />Pease note that the totals for Asia &amp; Europe are not simply the totals of their underlying Countries.</P><P>So in all I have two problems:</P><P>1) Make an Hierachy out of it assuming that i have the Hierarchy for Location in some othe Table with their Codes, how do i link/convert the above list to an Hierarchy.</P><P>2) Showing Subtotals for Countries whoch actually are not the Sum Totals of the Row.</P><P>Regards</P></BODY></HTML> Wed, 23 Jan 2013 09:21:48 GMT 2013-01-23T09:21:48Z Hierarchy & Sub Total from Linear Data https://community.qlik.com/t5/QlikView/Hierarchy-Sub-Total-from-Linear-Data/m-p/446575#M166609 <HTML><HEAD></HEAD><BODY><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="224" style="border: 1px solid rgb(0, 0, 0); width: 384px; height: 211px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Location</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD><P>Asia</P></TD><TD>10</TD></TR><TR><TD>Sri Lanka</TD><TD>1</TD></TR><TR><TD>China</TD><TD>2</TD></TR><TR><TD>Japan</TD><TD>3</TD></TR><TR><TD>Europe</TD><TD>7</TD></TR><TR><TD>Paris</TD><TD>1</TD></TR><TR><TD>Germany</TD><TD>4</TD></TR><TR><TD>Sweden</TD><TD>5</TD></TR><TR><TD>Denmark</TD><TD>1</TD></TR></TBODY></TABLE><P>I would like to represent the aboe in a pivot table with 1st column as </P><P>Continent having Values Asia &amp; Europe and 2nd column as sri Lanka,China,Japan for Asia</P><P>&amp; Paris,Germany,Sweden,Denmark for Europe</P><P>The value in each cell for the Coutry should show the values as above while the Sub Total for Asia shud be 10 &amp; for Europe shud b 7.</P><P><BR />Pease note that the totals for Asia &amp; Europe are not simply the totals of their underlying Countries.</P><P>So in all I have two problems:</P><P>1) Make an Hierachy out of it assuming that i have the Hierarchy for Location in some othe Table with their Codes, how do i link/convert the above list to an Hierarchy.</P><P>2) Showing Subtotals for Countries whoch actually are not the Sum Totals of the Row.</P><P>Regards</P></BODY></HTML> Wed, 23 Jan 2013 09:21:48 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Sub-Total-from-Linear-Data/m-p/446575#M166609 2013-01-23T09:21:48Z Re: Hierarchy & Sub Total from Linear Data https://community.qlik.com/t5/QlikView/Hierarchy-Sub-Total-from-Linear-Data/m-p/446576#M166610 <HTML><HEAD></HEAD><BODY><P>May be someone helps on this !!!</P></BODY></HTML> Wed, 23 Jan 2013 14:16:58 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Sub-Total-from-Linear-Data/m-p/446576#M166610 2013-01-23T14:16:58Z