topic Re: Set Analysis com Sum e DISTINCT in Brasil https://community.qlik.com/t5/Brasil/Set-Analysis-com-Sum-e-DISTINCT/m-p/732637#M21833 <HTML><HEAD></HEAD><BODY><P>Tonial, muito obrigado pela ajuda!</P></BODY></HTML> Mon, 25 Aug 2014 00:43:31 GMT 2014-08-25T00:43:31Z Set Analysis com Sum e DISTINCT https://community.qlik.com/t5/Brasil/Set-Analysis-com-Sum-e-DISTINCT/m-p/732635#M21831 <HTML><HEAD></HEAD><BODY><P>Pessoal, boa noite!</P><P></P><P>Preciso somar os Valores Totais de Contratos distintos.</P><P></P><P>Os Contratos estão em uma tabela com os Valores Totais e se repetem, pois há Valores Pagos em determinadas datas.</P><P></P><P>Exemplo:</P><P><STRONG><BR /></STRONG></P><P><STRONG>Tabela Contratos</STRONG></P><P></P><P>Nº Contrato&nbsp;&nbsp; Valor Total&nbsp;&nbsp; Valor Pago&nbsp;&nbsp; Data Pgto.</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.000,00&nbsp;&nbsp;&nbsp;&nbsp; 100,00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/01/2014</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.000,00&nbsp;&nbsp;&nbsp;&nbsp; 200,00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02/02/2014</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.000,00&nbsp;&nbsp;&nbsp;&nbsp; 300,00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03/03/2014</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.000,00&nbsp;&nbsp;&nbsp;&nbsp; 100,00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/01/2014</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.000,00&nbsp;&nbsp;&nbsp;&nbsp; 200,00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02/02/2014</P><P>...</P><P>Como somar o campo Valor Total, via Set Analysis, mas com o DISTINCT para o campo Nº Contrato?</P><P></P><P>Desde já, agradeço-lhes a atenção e a ajuda!</P></BODY></HTML> Sun, 24 Aug 2014 03:21:58 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-com-Sum-e-DISTINCT/m-p/732635#M21831 2014-08-24T03:21:58Z Re: Set Analysis com Sum e DISTINCT https://community.qlik.com/t5/Brasil/Set-Analysis-com-Sum-e-DISTINCT/m-p/732636#M21832 <HTML><HEAD></HEAD><BODY><P>Olá Tente assim:</P><P></P><P>Sum(Aggr(Sum(DISTINCT [Valor Total]), [Nº Contrato]))</P><P></P><P>Resultado.</P><P><IMG alt="24-08-2014 21-00-45.png" class="jive-image" src="/legacyfs/online/65065_24-08-2014 21-00-45.png" /></P><P></P><P>Qlikfique-se.</P><P>Tonial.</P></BODY></HTML> Mon, 25 Aug 2014 00:01:46 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-com-Sum-e-DISTINCT/m-p/732636#M21832 fernando_tonial 2014-08-25T00:01:46Z Re: Set Analysis com Sum e DISTINCT https://community.qlik.com/t5/Brasil/Set-Analysis-com-Sum-e-DISTINCT/m-p/732637#M21833 <HTML><HEAD></HEAD><BODY><P>Tonial, muito obrigado pela ajuda!</P></BODY></HTML> Mon, 25 Aug 2014 00:43:31 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-com-Sum-e-DISTINCT/m-p/732637#M21833 2014-08-25T00:43:31Z