topic Re: Função between in Brasil https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575312#M16080 <HTML><HEAD></HEAD><BODY><P>Olá Diogo,</P><P></P><P>Tudo vai depender do que você precisa.</P><P></P><P>Veja na ajuda do QlikView (F1).</P><P><SPAN class="Bold">TextBetween</SPAN></P><P><SPAN class="Bold"><SPAN class="Bold">match</SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold">mixmatch</SPAN></SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold">wildmatch</SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold">LOAD ... while; Não é LOAD ... where, é while mesmo! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold">Abraço.<BR /></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 29 Apr 2014 16:28:39 GMT aderlanrm 2014-04-29T16:28:39Z Função between https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575308#M16076 <HTML><HEAD></HEAD><BODY><P>Pessoal existe no QlikVIew uma função semelhante ao between dos SGBD?</P><P></P><P>Abs</P></BODY></HTML> Tue, 29 Apr 2014 14:05:02 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575308#M16076 diogoduarte 2014-04-29T14:05:02Z Re: Função between https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575309#M16077 <HTML><HEAD></HEAD><BODY><P>No!</P></BODY></HTML> Tue, 29 Apr 2014 14:08:06 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575309#M16077 alexandros17 2014-04-29T14:08:06Z Re: Função between https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575310#M16078 <HTML><HEAD></HEAD><BODY><P>Olha você consegue usar sim.</P><P></P><P>Eu faço uso, trabalhando com SET Analysis,</P><P></P><P>Exemplo</P><P></P><P>Count(</P><P>{&lt;</P><P>Dia_Jogo = {'&gt;$('2014-04-04') &lt;$(2014-04-10)'}</P><P>&gt;}</P><P>Quantidade_Jogador)</P><P> </P><P> </P><P><SPAN style="font-size: 12pt;">Exemplo 2 (Usando variaveis)</SPAN></P><P><STRONG style=": ; color: #0000ff; font-size: 12pt; text-decoration: underline;">COUNT</STRONG><SPAN style="font-size: 12pt;">(</SPAN><STRONG style=": ; color: #0000ff; font-size: 12pt;">DISTINCT</STRONG><SPAN style="font-size: 12pt;"><BR /><BR />{$<BR />&lt;</SPAN><SPAN style="color: #800000; font-size: 12pt;">[Flag Problema Estoque]</SPAN><SPAN style="font-size: 12pt;"> = {0}<BR />,</SPAN><SPAN style="color: #800000; font-size: 12pt;">[Quantidade Chamado Encerrado Estoque]</SPAN><SPAN style="font-size: 12pt;"> = {1}<BR />,</SPAN><SPAN style="color: #800000; font-size: 12pt;">[Data Ocorrência Estoque]</SPAN><SPAN style="font-size: 12pt;"> = {'&gt;=$(vUltimo15Dias)&lt;=$(vMaiorDiaSelecionado)'} <BR />&gt;} </SPAN><SPAN style="color: #800000; font-size: 12pt;">[ID Ticket Estoque]</SPAN><SPAN style="font-size: 12pt;"><BR /><BR /><BR /><BR />)<BR /><BR /> </SPAN></P><P></P></BODY></HTML> Tue, 29 Apr 2014 14:14:25 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575310#M16078 EduardoAlexandredeFrancisco 2014-04-29T14:14:25Z Re: Função between https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575311#M16079 <HTML><HEAD></HEAD><BODY><P>Como o Eduardo apontou acima ... seria um set analise com ideia de maior e menor ... dependendo do caso... coloque um exemplo talvez possamos ajuda-lo.</P><P></P><P>ok</P></BODY></HTML> Tue, 29 Apr 2014 15:30:56 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575311#M16079 mayck001 2014-04-29T15:30:56Z Re: Função between https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575312#M16080 <HTML><HEAD></HEAD><BODY><P>Olá Diogo,</P><P></P><P>Tudo vai depender do que você precisa.</P><P></P><P>Veja na ajuda do QlikView (F1).</P><P><SPAN class="Bold">TextBetween</SPAN></P><P><SPAN class="Bold"><SPAN class="Bold">match</SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold">mixmatch</SPAN></SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold">wildmatch</SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold">LOAD ... while; Não é LOAD ... where, é while mesmo! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold"><SPAN class="Bold">Abraço.<BR /></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 29 Apr 2014 16:28:39 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575312#M16080 aderlanrm 2014-04-29T16:28:39Z Re: Função between https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575313#M16081 <HTML><HEAD></HEAD><BODY><P>Com isto vai ajudar bastante.</P><P>Valeu Eduardo!</P></BODY></HTML> Tue, 29 Apr 2014 16:53:24 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575313#M16081 diogoduarte 2014-04-29T16:53:24Z Re: Função between https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575314#M16082 <HTML><HEAD></HEAD><BODY><P>Valeu Aderlan, mas estas funções não vão solucionar.</P><P>Mas obrigado!</P></BODY></HTML> Tue, 29 Apr 2014 16:53:49 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575314#M16082 diogoduarte 2014-04-29T16:53:49Z Re: Função between https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575315#M16083 <HTML><HEAD></HEAD><BODY><P>Mayck, quero funcionarios admitidos entra duas datas.</P><P>Estou resolvendo com IF data &gt; e data &lt; , com a solução do Eduardo também dá, mas se houvesse uma função específica.</P><P></P><P>Valeu</P></BODY></HTML> Tue, 29 Apr 2014 16:54:59 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575315#M16083 diogoduarte 2014-04-29T16:54:59Z Re: Função between https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575316#M16084 <HTML><HEAD></HEAD><BODY><P>Infelizmente não possui uma função específica para isso.</P><P>Temos que recorrer ao &gt; &lt; mesmo.</P></BODY></HTML> Tue, 29 Apr 2014 17:03:02 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-between/m-p/575316#M16084 Clever_Anjos 2014-04-29T17:03:02Z