topic Using sum value from straight table in QlikView https://community.qlik.com/t5/QlikView/Using-sum-value-from-straight-table/m-p/392993#M569302 <HTML><HEAD></HEAD><BODY><P>I have the following straight table in the front end: (Table's name is TabA)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 534px;"><TBODY><TR><TD class="xl63" height="18" width="102">Origin City Name</TD><TD class="xl63" style="border-left: none;" width="92">Code</TD><TD class="xl63" style="border-left: none;" width="102">PO Number</TD><TD class="xl63" style="border-left: none;" width="59">Value</TD><TD class="xl63" style="border-left: none;" width="77">Percentage</TD><TD class="xl63" style="border-left: none;" width="102">Sub parts</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101741</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">6.73</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.43%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.64</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101344</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8.54</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.81%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.81</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101361</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">4.69</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.00%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.45</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101787</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">44.93</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">4.82%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2.17</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101478</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5.02</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.06%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.48</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101789</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">7.36</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.56%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.70</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101970</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2.24</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.48%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.21</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101942</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10.35</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.20%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.99</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101853</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">44.94</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">8.94%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4.02</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101315</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">44.94</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">8.94%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4.02</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101603</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1.38</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.08%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.94</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101730</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">6.59</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9.94%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4.47</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101539</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">31.94</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">48.19%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">21.65</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101266</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0.86</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.27%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.57</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101510</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2.57</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3.87%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1.74</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101971</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1.59</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.40%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1.08</TD></TR><TR><TD class="xl69" height="18" style="border-top: none;">Sum</TD><TD class="xl69" style="border-top: none;">Sum</TD><TD class="xl69" style="border-top: none;">Sum</TD><TD align="right" class="xl70" style="border-top: none;">224.67</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">100.00%</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">44.93</TD></TR></TBODY></TABLE><P></P><P>Now, I want to create a dial using the sum of sub parts. Is there a way to reference the sum? </P><P></P><P>Any help will be much appreciated.</P><P></P><P>Thanks,</P><P>~H</P></BODY></HTML> Thu, 01 Nov 2012 17:31:14 GMT hibhardwaj 2012-11-01T17:31:14Z Using sum value from straight table https://community.qlik.com/t5/QlikView/Using-sum-value-from-straight-table/m-p/392993#M569302 <HTML><HEAD></HEAD><BODY><P>I have the following straight table in the front end: (Table's name is TabA)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 534px;"><TBODY><TR><TD class="xl63" height="18" width="102">Origin City Name</TD><TD class="xl63" style="border-left: none;" width="92">Code</TD><TD class="xl63" style="border-left: none;" width="102">PO Number</TD><TD class="xl63" style="border-left: none;" width="59">Value</TD><TD class="xl63" style="border-left: none;" width="77">Percentage</TD><TD class="xl63" style="border-left: none;" width="102">Sub parts</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101741</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">6.73</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.43%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.64</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101344</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8.54</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.81%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.81</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101361</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">4.69</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.00%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.45</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101787</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">44.93</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">4.82%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2.17</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101478</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5.02</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.06%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.48</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101789</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">7.36</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.56%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.70</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101970</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2.24</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.48%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.21</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101942</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10.35</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.20%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.99</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101853</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">44.94</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">8.94%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4.02</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101315</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">44.94</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">8.94%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4.02</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101603</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1.38</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.08%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.94</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101730</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">6.59</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9.94%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4.47</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101539</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">31.94</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">48.19%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">21.65</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101266</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0.86</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.27%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0.57</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101510</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2.57</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3.87%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1.74</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">CHENNAI</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100160</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">101971</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1.59</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.40%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1.08</TD></TR><TR><TD class="xl69" height="18" style="border-top: none;">Sum</TD><TD class="xl69" style="border-top: none;">Sum</TD><TD class="xl69" style="border-top: none;">Sum</TD><TD align="right" class="xl70" style="border-top: none;">224.67</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">100.00%</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">44.93</TD></TR></TBODY></TABLE><P></P><P>Now, I want to create a dial using the sum of sub parts. Is there a way to reference the sum? </P><P></P><P>Any help will be much appreciated.</P><P></P><P>Thanks,</P><P>~H</P></BODY></HTML> Thu, 01 Nov 2012 17:31:14 GMT https://community.qlik.com/t5/QlikView/Using-sum-value-from-straight-table/m-p/392993#M569302 hibhardwaj 2012-11-01T17:31:14Z Re: Using sum value from straight table https://community.qlik.com/t5/QlikView/Using-sum-value-from-straight-table/m-p/392994#M569303 <HTML><HEAD></HEAD><BODY><P>You can use the aggr() function based on the dimensions.</P></BODY></HTML> Thu, 01 Nov 2012 17:38:31 GMT https://community.qlik.com/t5/QlikView/Using-sum-value-from-straight-table/m-p/392994#M569303 2012-11-01T17:38:31Z