topic Dia -1 in Brasil https://community.qlik.com/t5/Brasil/Dia-1/m-p/660306#M18811 <HTML><HEAD></HEAD><BODY><P>Boa tarde pessoal,</P><P></P><P>Estou tentando fazer o seguinte calculo na tabela que tenho:</P><P></P><P>&nbsp;&nbsp; Data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Codigo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TC-1</P><P></P><P>09/08/14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BE002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1239&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">10/08/14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BE002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1252&nbsp;&nbsp;&nbsp;&nbsp; <STRONG> 1252-1239 = 13(este e o calculo o dia menos 1)</STRONG></SPAN></P><P></P><P></P><P>Preciso calcular o TC hoje menos ontem, como faço?</P><P></P><P>Att.</P></BODY></HTML> Mon, 11 Aug 2014 21:12:57 GMT 2014-08-11T21:12:57Z Dia -1 https://community.qlik.com/t5/Brasil/Dia-1/m-p/660306#M18811 <HTML><HEAD></HEAD><BODY><P>Boa tarde pessoal,</P><P></P><P>Estou tentando fazer o seguinte calculo na tabela que tenho:</P><P></P><P>&nbsp;&nbsp; Data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Codigo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TC-1</P><P></P><P>09/08/14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BE002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1239&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">10/08/14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BE002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1252&nbsp;&nbsp;&nbsp;&nbsp; <STRONG> 1252-1239 = 13(este e o calculo o dia menos 1)</STRONG></SPAN></P><P></P><P></P><P>Preciso calcular o TC hoje menos ontem, como faço?</P><P></P><P>Att.</P></BODY></HTML> Mon, 11 Aug 2014 21:12:57 GMT https://community.qlik.com/t5/Brasil/Dia-1/m-p/660306#M18811 2014-08-11T21:12:57Z Re: Dia -1 https://community.qlik.com/t5/Brasil/Dia-1/m-p/660307#M18812 <HTML><HEAD></HEAD><BODY><P>Veja se te atende, Saniffer:</P><P></P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14077955141958515" jivemacro_uid="_14077955141958515"> <P></P> <P></P> <P>TabTMP:</P> <P>LOAD</P> <P>&nbsp; Data,</P> <P>&nbsp; Codigo,</P> <P>&nbsp; TC</P> <P>FROM </P> <P>&lt;Fonte de Dados&gt;;</P> <P></P> <P></P> <P>Tab:</P> <P>LOAD </P> <P>&nbsp; Data,</P> <P>&nbsp; Codigo,</P> <P>&nbsp; TC,</P> <P>&nbsp; If(Codigo=Previous(Codigo), TC-Previous(TC), 0) as [TC-1]</P> <P>Resident TabTMP</P> <P>Order by Codigo, Data asc;</P> <P></P> <P></P> <P>DROP Table TabTMP;</P> </PRE><P></P><P>Abs,</P><P>Felipe</P></BODY></HTML> Mon, 11 Aug 2014 22:19:34 GMT https://community.qlik.com/t5/Brasil/Dia-1/m-p/660307#M18812 felipe_dutra 2014-08-11T22:19:34Z Re: Dia -1 https://community.qlik.com/t5/Brasil/Dia-1/m-p/660308#M18813 <HTML><HEAD></HEAD><BODY><P>Bom dia, muito obrigado usei o modelo em meus dados e funcionou perfeitamente...</P><P></P><P>Abraços..</P></BODY></HTML> Tue, 12 Aug 2014 12:16:06 GMT https://community.qlik.com/t5/Brasil/Dia-1/m-p/660308#M18813 2014-08-12T12:16:06Z Re: Dia -1 https://community.qlik.com/t5/Brasil/Dia-1/m-p/660309#M18814 <HTML><HEAD></HEAD><BODY><P>Amigo</P><P></P><P>Aproveito o assunto, para pedir sua nobre ajuda, necessito não utilizar os sabados e domingo e feriados no me calendario, como posso fazer, tem como me ajudar.</P><P></P><P>Agradeço</P></BODY></HTML> Wed, 08 Oct 2014 16:23:35 GMT https://community.qlik.com/t5/Brasil/Dia-1/m-p/660309#M18814 Anonymous 2014-10-08T16:23:35Z