topic Função de Agregação (SOMASES) in App Development

topic Função de Agregação (SOMASES) in App Development https://community.qlik.com/t5/App-Development/Fun%C3%A7%C3%A3o-de-Agrega%C3%A7%C3%A3o-SOMASES/m-p/116845#M8131 <HTML><HEAD></HEAD><BODY><P><SPAN style="vertical-align: inherit;">boa tarde, </SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">Preciso de Uma Ajuda, poderiam me Ajudar Como eu realizo o calculo Abaixo?</SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">Como Posso Calcular um cc Qtde?</SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">ELE somar APENAS OS campos Que Tem o Centro de Iguais Custo.</SPAN></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" width="472"><TBODY><TR><TD class="xl65" height="19" width="115"><SPAN style="vertical-align: inherit;">Clientes</SPAN></TD><TD class="xl65" width="156"><SPAN style="vertical-align: inherit;">Centro de Custo</SPAN></TD><TD class="xl65" width="71"><SPAN style="vertical-align: inherit;">Qtde</SPAN></TD><TD class="xl66" width="130"><SPAN style="vertical-align: inherit;">Qtde cc</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">1</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">2</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">3</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 4</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 5</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 6</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 7</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">2</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 8</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">6</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 9</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">5</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 10</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">2</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 11</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">5</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 12</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 13</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">2</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">16</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 14</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">1</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">16</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 15</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">16</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 16</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">16</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 17</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">5</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">16</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 23 Aug 2018 17:07:57 GMT rafael_jserpa 2018-08-23T17:07:57Z Função de Agregação (SOMASES) https://community.qlik.com/t5/App-Development/Fun%C3%A7%C3%A3o-de-Agrega%C3%A7%C3%A3o-SOMASES/m-p/116845#M8131 <HTML><HEAD></HEAD><BODY><P><SPAN style="vertical-align: inherit;">boa tarde, </SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">Preciso de Uma Ajuda, poderiam me Ajudar Como eu realizo o calculo Abaixo?</SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">Como Posso Calcular um cc Qtde?</SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">ELE somar APENAS OS campos Que Tem o Centro de Iguais Custo.</SPAN></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" width="472"><TBODY><TR><TD class="xl65" height="19" width="115"><SPAN style="vertical-align: inherit;">Clientes</SPAN></TD><TD class="xl65" width="156"><SPAN style="vertical-align: inherit;">Centro de Custo</SPAN></TD><TD class="xl65" width="71"><SPAN style="vertical-align: inherit;">Qtde</SPAN></TD><TD class="xl66" width="130"><SPAN style="vertical-align: inherit;">Qtde cc</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">1</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">2</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">3</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 4</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 5</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 6</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 1</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">18</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 7</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">2</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 8</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">6</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 9</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">5</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 10</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">2</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 11</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">5</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 12</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 2</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">24</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 13</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">2</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">16</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 14</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">1</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">16</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 15</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">16</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 16</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">4</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">16</SPAN></TD></TR><TR><TD class="xl63" height="19"><SPAN style="vertical-align: inherit;">Cliente 17</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">Centro de Custo 3</SPAN></TD><TD class="xl63"><SPAN style="vertical-align: inherit;">5</SPAN></TD><TD class="xl64"><SPAN style="vertical-align: inherit;">16</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 23 Aug 2018 17:07:57 GMT https://community.qlik.com/t5/App-Development/Fun%C3%A7%C3%A3o-de-Agrega%C3%A7%C3%A3o-SOMASES/m-p/116845#M8131 rafael_jserpa 2018-08-23T17:07:57Z