topic Re: Dúvida - Max() in Brasil https://community.qlik.com/t5/Brasil/D%C3%BAvida-Max/m-p/110632#M5996 <HTML><HEAD></HEAD><BODY><P>A resposta do Fernando Tonial resolveu teu problema ?</P></BODY></HTML> Sun, 08 Jul 2018 20:13:11 GMT pablolabbe 2018-07-08T20:13:11Z Dúvida - Max() https://community.qlik.com/t5/Brasil/D%C3%BAvida-Max/m-p/110630#M5994 <HTML><HEAD></HEAD><BODY><P><SPAN style="vertical-align: inherit;">boa tarde!</SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">Estou com Uma duvida, Comum, mas ....</SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">Tenho na base&nbsp; Ano e Mês e criei o campo: ANO_MES_2 </SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">Onde ANO_MES_2 = 201801&nbsp;&nbsp; </SPAN></P><P><SPAN style="vertical-align: inherit;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201802</SPAN></P><P><SPAN style="vertical-align: inherit;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201803 ... etc ...</SPAN></P><P><SPAN style="vertical-align: inherit;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Até 201807</SPAN></P><P></P><P></P><P><SPAN style="vertical-align: inherit;">criei Uma fórmula:</SPAN></P><P><SPAN style="vertical-align: inherit; font-size: 13.3333px;">= Sum ({&lt;ANO_MES_2 = $ {max (ANO_MES_2)}&gt;} Valor_Venda)</SPAN></P><P></P><P></P><P><SPAN style="vertical-align: inherit;">se eu peco SOMENTE max (ANO_MES_2), Traz certinho 201,807.</SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">No meu entendre Teria de me trazer Uma soma Valor_Venda Referente a 201.807.</SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">Mas ESTÁ me trazendo Uma somatória de todo o Período (201801 + 201802 + etc)</SPAN></P><P></P><P><SPAN style="vertical-align: inherit;"><SPAN style="vertical-align: inherit;">Alguém TEM ideia de Onde Estou Errando? </SPAN><SPAN style="vertical-align: inherit;">AINDA estou engatinhando em QlikSense</SPAN></SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">Obrigado!</SPAN></P></BODY></HTML> Wed, 04 Jul 2018 20:16:43 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-Max/m-p/110630#M5994 denytruyts 2018-07-04T20:16:43Z Re: Dúvida - Max() https://community.qlik.com/t5/Brasil/D%C3%BAvida-Max/m-p/110631#M5995 <HTML><HEAD></HEAD><BODY><P>Olá, </P><P></P><P>Aparentemente sua expressão está equivocada, tente assim:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">= Sum ({&lt;ANO_MES_2 = {$(=max (ANO_MES_2))}&gt;} Valor_Venda)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Don't worry, be Qlik.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Tonial.<BR /></SPAN></P></BODY></HTML> Thu, 05 Jul 2018 12:54:39 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-Max/m-p/110631#M5995 fernando_tonial 2018-07-05T12:54:39Z Re: Dúvida - Max() https://community.qlik.com/t5/Brasil/D%C3%BAvida-Max/m-p/110632#M5996 <HTML><HEAD></HEAD><BODY><P>A resposta do Fernando Tonial resolveu teu problema ?</P></BODY></HTML> Sun, 08 Jul 2018 20:13:11 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-Max/m-p/110632#M5996 pablolabbe 2018-07-08T20:13:11Z