topic Re: mês atual em numero in Brasil https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355880#M49358 <HTML><HEAD></HEAD><BODY><P>Tentou com S<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">um({1&lt; mesmonit={'$(=Month(Today()))'} &gt;}[QtdDiasMontoramento]) ?</SPAN></P></BODY></HTML> Mon, 26 Jun 2017 10:51:07 GMT Clever_Anjos 2017-06-26T10:51:07Z mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355879#M49357 <HTML><HEAD></HEAD><BODY><P>Bom dia,</P><P>Estou precisando criar uma expressão que some a quantidade de dias até o mês atual, fiz alguma tentativas mais não está funcionado.</P><P>LET vmesatu = num(Month(Today()),'00');</P><P>calendarioqtd:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp;&nbsp; mesmonit&nbsp;&nbsp; ,&nbsp;&nbsp; QtdDiasMontoramento&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 05&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 06&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 07&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 08&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 09&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31];</P><P></P><P>Existe a possibilidade da coluna <SPAN style="font-size: 13.3333px;">QtdDiasMontoramento se alimentada de acordo com o ano? como não estava sabendo fiz fixa.</SPAN></P><P></P><P>=Sum({1&lt; mesmonit={'1(=date(today(),''MM''))'} &gt;}[QtdDiasMontoramento])</P><P>=Sum({1&lt; mesmonit={'1(=num(=date(today(),''MM'')),''00'')'} &gt;}[QtdDiasMontoramento])</P><P>=Sum({1&lt; mesmonit={'1(=vmesatu)'} &gt;}[QtdDiasMontoramento])</P><P>=Sum({1&lt; mesmonit={'1(=Month(Today()))'} &gt;}[QtdDiasMontoramento])</P></BODY></HTML> Sun, 25 Jun 2017 15:05:37 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355879#M49357 Anonymous 2017-06-25T15:05:37Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355880#M49358 <HTML><HEAD></HEAD><BODY><P>Tentou com S<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">um({1&lt; mesmonit={'$(=Month(Today()))'} &gt;}[QtdDiasMontoramento]) ?</SPAN></P></BODY></HTML> Mon, 26 Jun 2017 10:51:07 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355880#M49358 Clever_Anjos 2017-06-26T10:51:07Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355881#M49359 <HTML><HEAD></HEAD><BODY><P>Clever,</P><P></P><P>O problema e que mesmonit está numérico (01,02....12) e <SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">= Month(Today()) volta (jan,fev...dez)</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">você saberia como fazer o <SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">= Month(Today()) retornar (01,02...12) e que possa utilizar na expressão? </SPAN><BR /></SPAN></P><P></P></BODY></HTML> Mon, 26 Jun 2017 11:59:43 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355881#M49359 Anonymous 2017-06-26T11:59:43Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355882#M49360 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;"> S</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000; background-color: #f2f2f2;">um({1&lt; mesmonit={'$(=Num(Month(Today())))'} &gt;}[QtdDiasMontoramento]) </SPAN></P></BODY></HTML> Mon, 26 Jun 2017 12:11:04 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355882#M49360 Clever_Anjos 2017-06-26T12:11:04Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355883#M49361 <HTML><HEAD></HEAD><BODY><P>Try this</P><P><SPAN style="color: #0000ff; font-size: 10pt;">Sum</SPAN><SPAN style="font-size: 10pt;">({1&lt; <SPAN style="color: #800000;">mesmonit</SPAN>={<SPAN style="color: #800000;">"$(=date(today(),'MM'))"</SPAN>} &gt;}<SPAN style="color: #800000;">[QtdDiasMontoramento]</SPAN>) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Mon, 26 Jun 2017 12:13:20 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355883#M49361 antoniotiman 2017-06-26T12:13:20Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355884#M49362 <HTML><HEAD></HEAD><BODY><P>Dessa forma ficou 0(Zero) o resultado.</P><P>Preciso somar.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; <STRONG> 01&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; 04&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; 05&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; 06&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; 07&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; 08&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; 09&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31];</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">31+28+31+30+31+30</P></BODY></HTML> Mon, 26 Jun 2017 12:29:57 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355884#M49362 Anonymous 2017-06-26T12:29:57Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355885#M49363 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Dessa forma ficou fixo em 30 Trinta o resultado</P></BODY></HTML> Mon, 26 Jun 2017 12:30:40 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355885#M49363 Anonymous 2017-06-26T12:30:40Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355886#M49364 <HTML><HEAD></HEAD><BODY><P>Sum({1&lt; mesmonit={"&lt;=$(=date(today(),'MM'))"} &gt;}[QtdDiasMontoramento])</P></BODY></HTML> Mon, 26 Jun 2017 12:34:09 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355886#M49364 Clever_Anjos 2017-06-26T12:34:09Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355887#M49365 <HTML><HEAD></HEAD><BODY><P>Clever,</P><P></P><P>Funcionou perfeitamente. Obrigado!</P><P></P><P>Só mais uma dúvida, existe alguma função que informe a quantidade de dias no mês?</P></BODY></HTML> Mon, 26 Jun 2017 12:39:57 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355887#M49365 Anonymous 2017-06-26T12:39:57Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355888#M49366 <HTML><HEAD></HEAD><BODY><P>Floor(MonthEnd(Today())-MonthStart(Today()))+1 ou</P><P></P><P>Floor(MonthEnd(CampoData)-MonthStart(<SPAN style="font-size: 13.3333px;">CampoData</SPAN>))+1</P></BODY></HTML> Mon, 26 Jun 2017 12:50:08 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355888#M49366 Clever_Anjos 2017-06-26T12:50:08Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355889#M49367 <HTML><HEAD></HEAD><BODY><P>Obrigado!</P></BODY></HTML> Mon, 26 Jun 2017 12:53:39 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355889#M49367 Anonymous 2017-06-26T12:53:39Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355890#M49368 <HTML><HEAD></HEAD><BODY><P>Amigo, bom dia, como vai?</P><P>Se possível e for o caso, marque as respostas apropriadas como Útil e/ou Correta para que outros membros possam saber que a sua pergunta foi respondida.</P><P></P><P>Para apoio;</P><P>Referência (Tópicos 2.3 e 2.4): <A href="https://community.qlik.com/docs/DOC-18510">Manual do usu&amp;amp;amp;aacute;rio | Como criar e gerir minhas perguntas?</A>‌</P><P></P><P>Abraço.</P></BODY></HTML> Tue, 27 Jun 2017 12:31:36 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355890#M49368 mario_sergio_ti 2017-06-27T12:31:36Z Re: mês atual em numero https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355891#M49369 <HTML><HEAD></HEAD><BODY><P>Bom Dia, Mario.</P><P></P><P>Obrigado. Ire fazer conforme orientação.</P></BODY></HTML> Sun, 02 Jul 2017 14:55:37 GMT https://community.qlik.com/t5/Brasil/m%C3%AAs-atual-em-numero/m-p/1355891#M49369 Anonymous 2017-07-02T14:55:37Z