topic Re: Somar Intervalo in Brasil https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573435#M16041 <HTML><HEAD></HEAD><BODY><P>Olá, tenta assim:</P><P></P><P>Count({$&lt;[HORA EMISSAO]={"&gt;=7&lt;19"}&gt;}[HORA EMISSAO])</P><P></P><P>Abraços.</P><P>Tonial.</P></BODY></HTML> Thu, 27 Feb 2014 02:39:52 GMT fernando_tonial 2014-02-27T02:39:52Z Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573420#M16026 <HTML><HEAD></HEAD><BODY><P>Como faço para somar o intervalo de ficha</P><P></P><P>ex:</P><P>7 as 19horas</P><P>19 as 7 horas</P><P></P><P></P><P></P><P><IMG alt="horas.png" class="jive-image" height="330" src="https://community.qlik.com/legacyfs/online/53883_horas.png" width="438" /></P></BODY></HTML> Wed, 26 Feb 2014 14:47:46 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573420#M16026 2014-02-26T14:47:46Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573421#M16027 <HTML><HEAD></HEAD><BODY><P>Terá que criar uma variável para pegar o intervalo :</P><P></P><P>Mais ou menos assim&nbsp; :</P><P></P><P>=Count({$&lt;Data_={"&gt;=$(=(date(Dt_Inicial)))&lt;=$(=(date(Dt_Final)))"}&gt;} Flag_Data)</P><P></P><P></P><P>Usar de acordo com os seus dados, nesse meu caso eu peguei o min(data) e max(data) da minha seleção.</P></BODY></HTML> Wed, 26 Feb 2014 16:40:53 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573421#M16027 2014-02-26T16:40:53Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573422#M16028 <HTML><HEAD></HEAD><BODY><P> Carlos</P><P></P><P>&nbsp; Coloquei essa formula : </P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[HORA EMISSAO]</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;=$(=(date(7)))&lt;=$(=(date(18)))"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[HORA EMISSAO]</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">&nbsp;&nbsp; Porém nao traz nada.</SPAN></P><P></P><P></P></BODY></HTML> Wed, 26 Feb 2014 17:08:29 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573422#M16028 2014-02-26T17:08:29Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573423#M16029 <HTML><HEAD></HEAD><BODY><P>Manda um arquivo em qvw para ser melhor analisado...</P></BODY></HTML> Wed, 26 Feb 2014 17:10:50 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573423#M16029 2014-02-26T17:10:50Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573424#M16030 <HTML><HEAD></HEAD><BODY><P><BR />Carlos</P><P></P><P></P><P>No post <A href="https://community.qlik.com/thread/108240">somar os 3 meses</A>&nbsp; tem um qvw chamado pep3.</P></BODY></HTML> Wed, 26 Feb 2014 17:15:16 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573424#M16030 2014-02-26T17:15:16Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573425#M16031 <HTML><HEAD></HEAD><BODY><P>Você quer somar os valores que estão nessa seleção em vermelho ?</P><P></P><P><IMG alt="ex.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/53904_ex.png" style="width: 620px; height: 326px;" /></P></BODY></HTML> Wed, 26 Feb 2014 17:24:30 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573425#M16031 2014-02-26T17:24:30Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573426#M16032 <HTML><HEAD></HEAD><BODY><P>Carlos</P><P></P><P></P><P>Isso mesmo , porem assim esta somando a cada 1 hora.</P><P></P><P>so que tem que ser assim : 7 as 18:59 horas e 19 as 6:59&nbsp; de janeiro&nbsp; etc....</P></BODY></HTML> Wed, 26 Feb 2014 17:39:17 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573426#M16032 2014-02-26T17:39:17Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573427#M16033 <HTML><HEAD></HEAD><BODY><P>tentou usa o comando "interval" ?</P><P></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Interval </SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">({$&lt;</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">[HORA EMISSAO]</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">) </SPAN></P></BODY></HTML> Wed, 26 Feb 2014 18:06:42 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573427#M16033 srchagas 2014-02-26T18:06:42Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573428#M16034 <HTML><HEAD></HEAD><BODY><P>Coloquei</P><P></P><P>Apresenta erro.</P><P></P><P><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[HORA EMISSAO]</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;=$(=(date(7)))&lt;=$(=(date(18)))"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[HORA EMISSAO]</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN></P><P></P></BODY></HTML> Wed, 26 Feb 2014 18:45:03 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573428#M16034 2014-02-26T18:45:03Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573429#M16035 <HTML><HEAD></HEAD><BODY><P>Vamos la, você quer um intervalo de Data / hora certo ?</P><P></P><P>Qual seria o parametro de datas para comparar?&nbsp; você vai setar fixo 7 e 18 ?</P></BODY></HTML> Wed, 26 Feb 2014 18:47:27 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573429#M16035 srchagas 2014-02-26T18:47:27Z Re: Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573430#M16036 <HTML><HEAD></HEAD><BODY><P>Amigo...seria isso ?</P><P></P><P>Ve qual dos dois te atende melhor imagino que seria isso que vc queria</P></BODY></HTML> Wed, 26 Feb 2014 19:02:23 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573430#M16036 srchagas 2014-02-26T19:02:23Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573431#M16037 <HTML><HEAD></HEAD><BODY><P>Thiago</P><P></P><P>Quero somar as fichas que estao no intervalo :</P><P></P><P>7 as 18:59 horas</P><P>19 as 6:59&nbsp; de janeiro&nbsp; etc....</P></BODY></HTML> Wed, 26 Feb 2014 19:05:00 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573431#M16037 2014-02-26T19:05:00Z Re: Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573432#M16038 <HTML><HEAD></HEAD><BODY><P>Acho que os exemplo resolvem então.</P></BODY></HTML> Wed, 26 Feb 2014 19:09:10 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573432#M16038 srchagas 2014-02-26T19:09:10Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573433#M16039 <HTML><HEAD></HEAD><BODY><P>Thiago</P><P></P><P>Esta quase certo</P><P></P><P> Só que nao precisa aparecer os horarios, segue exemlo da planilha.</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 580px;"><TBODY><TR><TD width="105"></TD><TD width="65">jan</TD><TD width="125">fev</TD><TD width="65">etc </TD></TR><TR><TD class="xl74" height="20"><BR />&nbsp; <P>7 as 18:59 </P></TD><TD>nº de ficha</TD><TD>nº de ficha</TD><TD>nº de ficha</TD></TR><TR><TD class="xl74" height="20">19 as 6:59 de <BR />&nbsp; </TD><TD>nº de ficha</TD><TD>nº de ficha</TD><TD>nº de ficha</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 26 Feb 2014 19:45:55 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573433#M16039 2014-02-26T19:45:55Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573434#M16040 <HTML><HEAD></HEAD><BODY><P>Mas a Hora Emissão é um Dimensão necessária para calcular a quantidade se tirar não funciona</P><P>tenta jogar essa formula no LOAD ai você pode conseguir por dia fazendo count desse cara</P><P></P><P> if ([HORA EMISSAO]&nbsp; &lt; 19 and&nbsp; [HORA EMISSAO] &gt; 7, '1','0') as Horario_ADM</P></BODY></HTML> Wed, 26 Feb 2014 20:33:59 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573434#M16040 srchagas 2014-02-26T20:33:59Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573435#M16041 <HTML><HEAD></HEAD><BODY><P>Olá, tenta assim:</P><P></P><P>Count({$&lt;[HORA EMISSAO]={"&gt;=7&lt;19"}&gt;}[HORA EMISSAO])</P><P></P><P>Abraços.</P><P>Tonial.</P></BODY></HTML> Thu, 27 Feb 2014 02:39:52 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573435#M16041 fernando_tonial 2014-02-27T02:39:52Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573436#M16042 <HTML><HEAD></HEAD><BODY><P>Faz o que Mestre Fernando falou</P><P></P><P>Count({$&lt;[HORA EMISSAO]={"&gt;=7&lt;19"}&gt;}[HORA EMISSAO])</P><P>e</P><P>Count({$&lt;[HORA EMISSAO]={"&gt;=19&lt;7"}&gt;}[HORA EMISSAO])</P><P></P><P>Criando essas duas expressões resolve.</P></BODY></HTML> Thu, 27 Feb 2014 12:17:19 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573436#M16042 srchagas 2014-02-27T12:17:19Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573437#M16043 <HTML><HEAD></HEAD><BODY><P>Tonial e Thiago</P><P></P><P> Consegui fazer com essas expressoes porem alterei no final coloquei a tabela da ficha : ficando assim </P><P></P><P></P><P><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[HORA EMISSAO]</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;=7&lt;19"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[COD_MDL_DOC]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[HORA EMISSAO]</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;=19&lt;7"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[COD_MDL_DOC]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><IMG alt="emissao.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/53976_emissao.png" /></P><P></P><P>valeu......</P></BODY></HTML> Thu, 27 Feb 2014 16:22:47 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573437#M16043 2014-02-27T16:22:47Z Re: Somar Intervalo https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573438#M16044 <HTML><HEAD></HEAD><BODY><P>Beleza cara, o importante é que você conseguiu resolver!</P></BODY></HTML> Fri, 28 Feb 2014 17:38:17 GMT https://community.qlik.com/t5/Brasil/Somar-Intervalo/m-p/573438#M16044 srchagas 2014-02-28T17:38:17Z