topic Re: Filtrando DATA in Brasil https://community.qlik.com/t5/Brasil/Filtrando-DATA/m-p/827037#M26539 <HTML><HEAD></HEAD><BODY><P>Olá Matheus,</P><P></P><P>Você pode utiliza a função Index().</P><P></P><P>If(Index(Campo,'10:30:00'),'10:30:00',Null()) AS CampoNovo</P><P></P><P>Qlikfique-se.</P><P>Tonial.</P></BODY></HTML> Thu, 27 Nov 2014 15:12:41 GMT fernando_tonial 2014-11-27T15:12:41Z Filtrando DATA https://community.qlik.com/t5/Brasil/Filtrando-DATA/m-p/827036#M26538 <HTML><HEAD></HEAD><BODY><P>Bom dia pessoal !</P><P>Estou tentando realizar um filtro em minha carga, porém sem sucesso...</P><P>Vamos lá,</P><P></P><P>Eu tenho um campo que contém, um "array" fazendo a contagem de quanto tempo meu serviço ficou online.</P><P>Esse é a estrutura do campo:</P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1443px;"> <TBODY> <TR> <TD class="xl63" height="17" width="1443">["07:20:00","07:30:00","07:40:00","07:50:00","08:00:00","08:10:00","08:20:00","08:30:00","08:40:00","08:50:00","09:00:00","09:10:00","09:20:00","09:30:00","09:40:00","09:50:00","13:40:00","13:50:00","14:00:00"]</TD> </TR> <TR> <TD class="xl63" height="17" style="border-top: none;">["06:20:00","06:30:00","06:40:00","06:50:00","07:00:00","07:10:00","07:20:00","07:30:00","07:40:00","07:50:00","08:00:00","08:10:00","08:20:00","08:30:00","08:40:00","08:50:00","09:00:00","09:10:00","09:20:00","09:30:00","09:40:00","09:50:00","10:00:00","10:10:00","10:20:00","10:40:00","10:50:00","11:10:00","11:20:00","12:00:00","12:10:00","12:20:00","12:30:00","12:40:00","12:50:00","13:10:00","13:20:00","13:30:00","13:40:00","13:50:00","14:00:00"]</TD> </TR> <TR> <TD class="xl63" height="17" style="border-top: none;">["09:30:00"]</TD> </TR> <TR> <TD class="xl63" height="17" style="border-top: none;">["09:20:00","12:20:00","12:30:00","12:40:00","12:50:00","13:00:00","13:10:00","13:20:00","13:30:00"]</TD> </TR> </TBODY> </TABLE> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>Preciso que na carga se existir o valor "10:30:00" na linha ele guarde esse valor em um novo campo, se não existir o valor no campo é nulo.</P><P></P><P></P><P></P><P>Espero ter conseguido explicar.</P><P>Obrigado.</P><P>Abraços.</P></BODY></HTML> Thu, 27 Nov 2014 14:48:37 GMT https://community.qlik.com/t5/Brasil/Filtrando-DATA/m-p/827036#M26538 Anonymous 2014-11-27T14:48:37Z Re: Filtrando DATA https://community.qlik.com/t5/Brasil/Filtrando-DATA/m-p/827037#M26539 <HTML><HEAD></HEAD><BODY><P>Olá Matheus,</P><P></P><P>Você pode utiliza a função Index().</P><P></P><P>If(Index(Campo,'10:30:00'),'10:30:00',Null()) AS CampoNovo</P><P></P><P>Qlikfique-se.</P><P>Tonial.</P></BODY></HTML> Thu, 27 Nov 2014 15:12:41 GMT https://community.qlik.com/t5/Brasil/Filtrando-DATA/m-p/827037#M26539 fernando_tonial 2014-11-27T15:12:41Z