topic Re: Data semanal in Brasil https://community.qlik.com/t5/Brasil/Data-semanal/m-p/914079#M30822 <HTML><HEAD></HEAD><BODY><P>é possível sim, basta filtrar via Set Analysis suas expressões Realizado/Previsto e Saldo. Temo como postar a expressão?</P></BODY></HTML> Thu, 06 Aug 2015 14:04:20 GMT Clever_Anjos 2015-08-06T14:04:20Z Data semanal https://community.qlik.com/t5/Brasil/Data-semanal/m-p/914078#M30821 <HTML><HEAD></HEAD><BODY><P>Meus caros, estou tentando trabalhar com semanas e adaptei um código explicado pelo <A href="https://community.qlik.com/qlik-users/21667">cleveranjos</A>‌ que ficou da seguinte forma:</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">dual</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">(<BR /> </SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">date</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">WeekStart</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: maroon;">DATA</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">),'DD/MMM') &amp; ' a ' &amp; </SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">Date</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">WeekEnd</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: maroon;">DATA</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">),'DD/MMM'),<BR /> </SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">WeekStart</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: maroon;">DATA</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">)<BR /> ) </SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">as</SPAN> <SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: maroon;">Week</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">, </SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">Este código está me retornando o seguinte:</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;"><IMG alt="arrec.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95242_arrec.png" style="height: auto;" /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">Notem que na última semana o dia 06/set está aparecendo. Eu gostaria que aparecesse somente até o dia 31/ago.</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">É possível ?</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">Obrigado</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">Abs<BR /></SPAN></P></BODY></HTML> Thu, 06 Aug 2015 14:02:40 GMT https://community.qlik.com/t5/Brasil/Data-semanal/m-p/914078#M30821 Anonymous 2015-08-06T14:02:40Z Re: Data semanal https://community.qlik.com/t5/Brasil/Data-semanal/m-p/914079#M30822 <HTML><HEAD></HEAD><BODY><P>é possível sim, basta filtrar via Set Analysis suas expressões Realizado/Previsto e Saldo. Temo como postar a expressão?</P></BODY></HTML> Thu, 06 Aug 2015 14:04:20 GMT https://community.qlik.com/t5/Brasil/Data-semanal/m-p/914079#M30822 Clever_Anjos 2015-08-06T14:04:20Z Re: Data semanal https://community.qlik.com/t5/Brasil/Data-semanal/m-p/914080#M30823 <HTML><HEAD></HEAD><BODY><P>Olá Ricardo!</P><P></P><P>Ajustei a sua expressão.</P><P>Veja se apresenta o resultado que esperava.</P><P></P><P>dual(</P><P>date(RangeMax(WeekStart(DATA), MonthStart(DATA)),'DD/MMM') &amp; ' a ' &amp; Date(RangeMin(WeekEnd(DATA), MonthEnd(DATA)),'DD/MMM'),</P><P>RangeMax(WeekStart(DATA), MonthStart(DATA))</P><P>) as Week</P><P></P><P>Abs,</P><P>Felipe</P></BODY></HTML> Thu, 06 Aug 2015 15:57:01 GMT https://community.qlik.com/t5/Brasil/Data-semanal/m-p/914080#M30823 felipe_dutra 2015-08-06T15:57:01Z Re: Data semanal https://community.qlik.com/t5/Brasil/Data-semanal/m-p/914081#M30824 <HTML><HEAD></HEAD><BODY><P>Muito bom. Era exatamente isso que eu queria.</P><P></P><P>Muito obrigado</P></BODY></HTML> Thu, 06 Aug 2015 17:00:51 GMT https://community.qlik.com/t5/Brasil/Data-semanal/m-p/914081#M30824 Anonymous 2015-08-06T17:00:51Z