topic Re: Ordenar Filtro in Brasil https://community.qlik.com/t5/Brasil/Ordenar-Filtro/m-p/1249588#M44482 <HTML><HEAD></HEAD><BODY><P>Sort by Expression</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0000ff;">Date(WeekStart(DATA,0,0),'DD/MM')</SPAN></P></BODY></HTML> Sat, 14 Jan 2017 11:58:21 GMT vinieme12 2017-01-14T11:58:21Z Ordenar Filtro https://community.qlik.com/t5/Brasil/Ordenar-Filtro/m-p/1249587#M44481 <HTML><HEAD></HEAD><BODY><P>Bom Dia à Todos..!!</P><P></P><P>Tenho uma função para trabalhar com as semanas, porém não consigo ordenar o painel de filtro nem outros objetos quando utilizo esta função.</P><P>Já tentei de várias formas e não consegui. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P><P></P><P>Preciso ordenar de acordo com as semanas.</P><P></P><P><SPAN style="color: #0000ff;">Date(WeekStart(DATA,0,0),'DD/MM')&amp;' a '&amp;Date(WeekEnd(DATA,0,0),'DD/MM')</SPAN></P><P></P><P>Será que alguém poderia me ajudar ? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P><P></P><P>Segue o qvf em anexo.</P><P></P><P>Muito Obrigado.</P><P></P><P>Renato</P></BODY></HTML> Sat, 14 Jan 2017 11:30:01 GMT https://community.qlik.com/t5/Brasil/Ordenar-Filtro/m-p/1249587#M44481 girino777 2017-01-14T11:30:01Z Re: Ordenar Filtro https://community.qlik.com/t5/Brasil/Ordenar-Filtro/m-p/1249588#M44482 <HTML><HEAD></HEAD><BODY><P>Sort by Expression</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0000ff;">Date(WeekStart(DATA,0,0),'DD/MM')</SPAN></P></BODY></HTML> Sat, 14 Jan 2017 11:58:21 GMT https://community.qlik.com/t5/Brasil/Ordenar-Filtro/m-p/1249588#M44482 vinieme12 2017-01-14T11:58:21Z Re: Ordenar Filtro https://community.qlik.com/t5/Brasil/Ordenar-Filtro/m-p/1249589#M44483 <HTML><HEAD></HEAD><BODY><P>Bom Dia.!</P><P></P><P>Já tentei desta forma, mas não funciona..!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P></BODY></HTML> Sat, 14 Jan 2017 12:05:02 GMT https://community.qlik.com/t5/Brasil/Ordenar-Filtro/m-p/1249589#M44483 girino777 2017-01-14T12:05:02Z Re: Ordenar Filtro https://community.qlik.com/t5/Brasil/Ordenar-Filtro/m-p/1249590#M44484 <HTML><HEAD></HEAD><BODY><P>Renato,</P><P></P><P>usa dual() e o texto fica do jeito que você quer e na parte numérica poe o ano e semana para ordenar....</P><P></P><P><IMG alt="2017-01-14 10_52_45-Qlik Sense Desktop.png" class="jive-image image-1" src="/legacyfs/online/149495_2017-01-14 10_52_45-Qlik Sense Desktop.png" style="height: auto;" /></P><P></P><P>&nbsp;&nbsp; dual(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date(WeekStart(DATA,0,0),'DD/MM')&amp;' a '&amp;Date(WeekEnd(DATA,0,0),'DD/MM')&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // TXT</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year(DATA) &amp; '.' &amp; Week(DATA)&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;&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // NUM</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp; as Semana</P></BODY></HTML> Sat, 14 Jan 2017 12:57:25 GMT https://community.qlik.com/t5/Brasil/Ordenar-Filtro/m-p/1249590#M44484 afurtado 2017-01-14T12:57:25Z