https://community.qlik.com/t5/Brasil/Somar-Ultimo-Valor-da-Ultima-Data/m-p/2039942#M60613 <P>Deu certo, obrigado.</P> Mon, 20 Feb 2023 14:59:02 GMT spader 2023-02-20T14:59:02Z https://community.qlik.com/t5/Brasil/Somar-Ultimo-Valor-da-Ultima-Data/m-p/2038398#M60606 <P>Boa tarde pessoal, tenho uma planilha (abaixo) onde informo a contagem física em estoque, e mostro numa tabela do Qlik Sense sempre o ultimo registro da ultima data conforme imagem abaixo usando o <STRONG>FirstSortedValue(Contagem, -Data)</STRONG>.&nbsp;</P> <TABLE width="375"> <TBODY> <TR> <TD width="73.7px" height="24px">Empresa</TD> <TD width="77.7375px" height="24px">Safra</TD> <TD width="85.55px" height="24px">Data</TD> <TD width="137.212px" height="24px">Contagem&nbsp;</TD> </TR> <TR> <TD width="73.7px" height="24px">8</TD> <TD width="77.7375px" height="24px">2023</TD> <TD width="85.55px" height="24px">10/02/2023</TD> <TD width="137.212px" height="24px">10000</TD> </TR> <TR> <TD width="73.7px" height="24px">28</TD> <TD width="77.7375px" height="24px">2023</TD> <TD width="85.55px" height="24px">10/02/2023</TD> <TD width="137.212px" height="24px">15000</TD> </TR> <TR> <TD width="73.7px" height="24px">38</TD> <TD width="77.7375px" height="24px">2023</TD> <TD width="85.55px" height="24px">10/02/2023</TD> <TD width="137.212px" height="24px">15000</TD> </TR> <TR> <TD width="73.7px" height="24px">58</TD> <TD width="77.7375px" height="24px">2023</TD> <TD width="85.55px" height="24px">10/02/2023</TD> <TD width="137.212px" height="24px">15000</TD> </TR> <TR> <TD width="73.7px" height="24px">8</TD> <TD width="77.7375px" height="24px">2023</TD> <TD width="85.55px" height="24px">15/02/2023</TD> <TD width="137.212px" height="24px">30000</TD> </TR> </TBODY> </TABLE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="spader_0-1676486675617.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/100618iEC57A9A32EF10329/image-size/medium?v=v2&amp;px=400" role="button" title="spader_0-1676486675617.png" alt="spader_0-1676486675617.png" /></span></P> <P>Agora estou precisando realizar a soma desses ultimos registros, tentei usando&nbsp;<STRONG>sum(Aggr(FirstSortedValue(Contagem,Data), &lt;Contagem&gt;))</STRONG> porém me retorna zero. Podem me ajudar?</P> <P>&nbsp;</P> Wed, 15 Feb 2023 18:49:32 GMT https://community.qlik.com/t5/Brasil/Somar-Ultimo-Valor-da-Ultima-Data/m-p/2038398#M60606 spader 2023-02-15T18:49:32Z https://community.qlik.com/t5/Brasil/Somar-Ultimo-Valor-da-Ultima-Data/m-p/2039400#M60611 <P>Olá,&nbsp;</P> <P>Entendo que deve fazer algumas alterações na sua expressão.</P> <P>Da forma abaixo deve funcionar.</P> <LI-CODE lang="markup">Sum(Aggr(FirstSortedValue(Contagem,-Data), Empresa))</LI-CODE> <P>&nbsp;</P> <P>Don't worry, be Qlik.<BR />Tonial</P> Fri, 17 Feb 2023 17:36:33 GMT https://community.qlik.com/t5/Brasil/Somar-Ultimo-Valor-da-Ultima-Data/m-p/2039400#M60611 fernando_tonial 2023-02-17T17:36:33Z https://community.qlik.com/t5/Brasil/Somar-Ultimo-Valor-da-Ultima-Data/m-p/2039942#M60613 <P>Deu certo, obrigado.</P> Mon, 20 Feb 2023 14:59:02 GMT https://community.qlik.com/t5/Brasil/Somar-Ultimo-Valor-da-Ultima-Data/m-p/2039942#M60613 spader 2023-02-20T14:59:02Z