topic Re: Include totalizer % in QlikView https://community.qlik.com/t5/QlikView/Include-totalizer/m-p/698904#M540569 <HTML><HEAD></HEAD><BODY><P>Fala Silva,</P><P></P><P>O que representa esse %? </P><P></P><P>Pois há varias formas de se fazer esse cálculo.</P><P></P><P>Uma delas é na própria aba de expressão (ex: sum(Vol) ) marcar a opção 'relativo', os valores automaticamente serão apresentados em %.</P><P></P><P>Abraços,</P><P></P><P>Nilo</P></BODY></HTML> Thu, 17 Jul 2014 15:15:22 GMT nilo_pontes 2014-07-17T15:15:22Z Include totalizer % https://community.qlik.com/t5/QlikView/Include-totalizer/m-p/698903#M540568 <HTML><HEAD></HEAD><BODY><P>Hello </P><P></P><P></P><P>Need to include a column equal to "Total TX" how should I do?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 490px;"><TBODY><TR><TD class="xl63" height="20" width="64">Cliente</TD><TD class="xl63" style="border-left: none;" width="90"> </TD><TD class="xl65" style="border-left: none;" width="80"> </TD><TD class="xl63" style="border-left: none;" width="64">Jan</TD><TD class="xl63" style="border-left: none;" width="64">Fev</TD><TD class="xl63" style="border-left: none;" width="64">Mar</TD><TD class="xl63" style="border-left: none;" width="64">Abr</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"> </TD><TD class="xl64" style="border-top: none; border-left: none;">Total Vol</TD><TD class="xl66" style="border-top: none; border-left: none;">Total TX</TD><TD class="xl64" style="border-top: none; border-left: none;">Vol</TD><TD class="xl64" style="border-top: none; border-left: none;">Vol</TD><TD class="xl64" style="border-top: none; border-left: none;">Vol</TD><TD class="xl64" style="border-top: none; border-left: none;">Vol</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Teste</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">154</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">11%</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">29</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">48</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">67</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Teste 01</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">194</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">100%</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">39</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">58</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">77</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Teste 02</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">234</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99%</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">49</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">68</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">87</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Teste 03</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">434</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">75%</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">80</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">99</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">118</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">137</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Teste 04</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">370</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">64%</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">64</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">83</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">102</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">121</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Teste 05</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">210</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15%</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">24</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">43</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">62</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">81</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Teste 06</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">510</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">25%</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">99</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">118</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">137</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">156</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 17 Jul 2014 14:23:57 GMT https://community.qlik.com/t5/QlikView/Include-totalizer/m-p/698903#M540568 2014-07-17T14:23:57Z Re: Include totalizer % https://community.qlik.com/t5/QlikView/Include-totalizer/m-p/698904#M540569 <HTML><HEAD></HEAD><BODY><P>Fala Silva,</P><P></P><P>O que representa esse %? </P><P></P><P>Pois há varias formas de se fazer esse cálculo.</P><P></P><P>Uma delas é na própria aba de expressão (ex: sum(Vol) ) marcar a opção 'relativo', os valores automaticamente serão apresentados em %.</P><P></P><P>Abraços,</P><P></P><P>Nilo</P></BODY></HTML> Thu, 17 Jul 2014 15:15:22 GMT https://community.qlik.com/t5/QlikView/Include-totalizer/m-p/698904#M540569 nilo_pontes 2014-07-17T15:15:22Z