topic Re: Somar valores agregados in Brasil https://community.qlik.com/t5/Brasil/Somar-valores-agregados/m-p/39712#M2059 <HTML><HEAD></HEAD><BODY><P>Isso mesmo obrigado!</P></BODY></HTML> Mon, 02 Apr 2018 16:04:41 GMT Anonymous 2018-04-02T16:04:41Z Somar valores agregados https://community.qlik.com/t5/Brasil/Somar-valores-agregados/m-p/39710#M2057 <HTML><HEAD></HEAD><BODY><P>Pessoal bom dia,</P><P></P><P>Como eu posso fazer pra somar meus registros dessa forma, tenho varias notas, porém tenho outra coluna com prazo, no final preciso do prazo médio, mas preciso somar apenas uma vez o valor de cada nota, os prazos se repetem devido aos itens da nota, porém preciso somar apenas o prazo da nota. Nesse exemplo eu teria na soma total dos prazos o valor : 11 dias de prazo.</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px;"><TBODY><TR><TD height="20" width="64">Nota</TD><TD width="64">Prazo</TD></TR><TR><TD align="right" height="20">694622</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">694622</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">694622</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">694622</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">694622</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">694622</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">694622</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">694864</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">694864</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">694864</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">694864</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">694864</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">694864</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">694864</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">694864</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">694864</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">695241</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">696378</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">696378</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">696378</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">696378</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">696378</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">696378</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">696902</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">696902</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">696902</TD><TD align="right">1</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 02 Apr 2018 14:02:18 GMT https://community.qlik.com/t5/Brasil/Somar-valores-agregados/m-p/39710#M2057 Anonymous 2018-04-02T14:02:18Z Re: Somar valores agregados https://community.qlik.com/t5/Brasil/Somar-valores-agregados/m-p/39711#M2058 <HTML><HEAD></HEAD><BODY><P>Pedro, seria isso?</P><P></P><P><STRONG>Sum(Aggr(Sum(Distinct Prazo),Nota))</STRONG></P></BODY></HTML> Mon, 02 Apr 2018 14:55:43 GMT https://community.qlik.com/t5/Brasil/Somar-valores-agregados/m-p/39711#M2058 Thiago_Justen_ 2018-04-02T14:55:43Z Re: Somar valores agregados https://community.qlik.com/t5/Brasil/Somar-valores-agregados/m-p/39712#M2059 <HTML><HEAD></HEAD><BODY><P>Isso mesmo obrigado!</P></BODY></HTML> Mon, 02 Apr 2018 16:04:41 GMT https://community.qlik.com/t5/Brasil/Somar-valores-agregados/m-p/39712#M2059 Anonymous 2018-04-02T16:04:41Z