topic Re: Max Data dentro do Set Analysis in App Development https://community.qlik.com/t5/App-Development/Max-Data-dentro-do-Set-Analysis/m-p/62452#M4132 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 470px;"><TBODY><TR><TD class="xl66" colspan="5" height="20" width="203">Tabela</TD><TD class="xl66" colspan="4" width="203">o que preciso</TD></TR><TR><TD height="20">nome</TD><TD>dt</TD><TD>valor</TD><TD></TD><TD></TD><TD></TD><TD><STRONG>nome</STRONG></TD><TD><STRONG>dt</STRONG></TD><TD class="xl67"><STRONG>valor</STRONG></TD></TR><TR><TD height="20">abacate</TD><TD align="right" class="xl65">01/01/2018</TD><TD align="right">10</TD><TD align="right"></TD><TD align="right"></TD><TD></TD><TD><STRONG>abacate</STRONG></TD><TD align="right" class="xl65"><STRONG>02/01/2018</STRONG></TD><TD align="right" class="xl67"><STRONG>9</STRONG></TD></TR><TR><TD height="20">abacate</TD><TD align="right" class="xl65">02/01/2018</TD><TD align="right">9</TD><TD align="right"></TD><TD align="right"></TD><TD></TD><TD><STRONG>abacaxi</STRONG></TD><TD align="right" class="xl65"><STRONG>04/01/2018</STRONG></TD><TD align="right" class="xl67"><STRONG>16</STRONG></TD></TR><TR><TD height="20">abacaxi</TD><TD align="right" class="xl65">03/01/2018</TD><TD align="right">15</TD><TD align="right"></TD><TD align="right"></TD></TR><TR><TD height="20">abacaxi</TD><TD align="right" class="xl65">04/01/2018</TD><TD align="right">16</TD><TD align="right"></TD><TD align="right"></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 05 Apr 2018 15:03:35 GMT gleybson_calyx 2018-04-05T15:03:35Z Max Data dentro do Set Analysis https://community.qlik.com/t5/App-Development/Max-Data-dentro-do-Set-Analysis/m-p/62450#M4130 <HTML><HEAD></HEAD><BODY><P>Ola pessoal,</P><P>gostaria de saber como fazer para retornar a max(Data) dentro do Set Analysis.</P><P>Na imagem abaixo mostro que ao selecionar o pro produto ele mostra o valor e quando não tem produto selecionar (Comunidade2) ele não traz.</P><P></P><P>exeplos que eu já tentei:</P><P>sum( {&lt;AnoMesDia = {'$(=MAX(AnoMesDia))'} &gt;} VALOR )</P><P></P><P>sum( {&lt;AnoMesDia = {"$(=MAX(AnoMesDia))"} &gt;} VALOR )</P><P></P><P><IMG alt="Comunidade01.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/198603_Comunidade01.png" style="height: 191px; width: 620px;" /></P><P><IMG alt="comunidade02.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/198604_comunidade02.png" style="height: 225px; width: 620px;" /></P></BODY></HTML> Thu, 05 Apr 2018 13:35:48 GMT https://community.qlik.com/t5/App-Development/Max-Data-dentro-do-Set-Analysis/m-p/62450#M4130 gleybson_calyx 2018-04-05T13:35:48Z Re: Max Data dentro do Set Analysis https://community.qlik.com/t5/App-Development/Max-Data-dentro-do-Set-Analysis/m-p/62451#M4131 <HTML><HEAD></HEAD><BODY><P>Alguém tem alguma sugestão?</P></BODY></HTML> Thu, 05 Apr 2018 14:38:30 GMT https://community.qlik.com/t5/App-Development/Max-Data-dentro-do-Set-Analysis/m-p/62451#M4131 gleybson_calyx 2018-04-05T14:38:30Z Re: Max Data dentro do Set Analysis https://community.qlik.com/t5/App-Development/Max-Data-dentro-do-Set-Analysis/m-p/62452#M4132 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 470px;"><TBODY><TR><TD class="xl66" colspan="5" height="20" width="203">Tabela</TD><TD class="xl66" colspan="4" width="203">o que preciso</TD></TR><TR><TD height="20">nome</TD><TD>dt</TD><TD>valor</TD><TD></TD><TD></TD><TD></TD><TD><STRONG>nome</STRONG></TD><TD><STRONG>dt</STRONG></TD><TD class="xl67"><STRONG>valor</STRONG></TD></TR><TR><TD height="20">abacate</TD><TD align="right" class="xl65">01/01/2018</TD><TD align="right">10</TD><TD align="right"></TD><TD align="right"></TD><TD></TD><TD><STRONG>abacate</STRONG></TD><TD align="right" class="xl65"><STRONG>02/01/2018</STRONG></TD><TD align="right" class="xl67"><STRONG>9</STRONG></TD></TR><TR><TD height="20">abacate</TD><TD align="right" class="xl65">02/01/2018</TD><TD align="right">9</TD><TD align="right"></TD><TD align="right"></TD><TD></TD><TD><STRONG>abacaxi</STRONG></TD><TD align="right" class="xl65"><STRONG>04/01/2018</STRONG></TD><TD align="right" class="xl67"><STRONG>16</STRONG></TD></TR><TR><TD height="20">abacaxi</TD><TD align="right" class="xl65">03/01/2018</TD><TD align="right">15</TD><TD align="right"></TD><TD align="right"></TD></TR><TR><TD height="20">abacaxi</TD><TD align="right" class="xl65">04/01/2018</TD><TD align="right">16</TD><TD align="right"></TD><TD align="right"></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 05 Apr 2018 15:03:35 GMT https://community.qlik.com/t5/App-Development/Max-Data-dentro-do-Set-Analysis/m-p/62452#M4132 gleybson_calyx 2018-04-05T15:03:35Z Re: Max Data dentro do Set Analysis https://community.qlik.com/t5/App-Development/Max-Data-dentro-do-Set-Analysis/m-p/62453#M4133 <HTML><HEAD></HEAD><BODY><P>FirstSortedValue({&lt;Tipo = {'Entradas'}&gt;}&nbsp; VALOR,-DATA)</P></BODY></HTML> Thu, 05 Apr 2018 18:37:42 GMT https://community.qlik.com/t5/App-Development/Max-Data-dentro-do-Set-Analysis/m-p/62453#M4133 gleybson_calyx 2018-04-05T18:37:42Z