topic Controle de Entrada e Saida in Brasil https://community.qlik.com/t5/Brasil/Controle-de-Entrada-e-Saida/m-p/883514#M29338 <HTML><HEAD></HEAD><BODY><P>Estou criando um controle de entrada e saída para um trabalho no meu curso, estou iniciando e começo muito pouco. Poderiam me ajudar, Realizei a importação da minha planilha para a ferramenta Qlik Qual dessas opções eu consigo abrir as informações que foram importadas.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/91889_pastedImage_1.png" /></P><P>OBS: Tenho três colunas (Data, Entrada e Saída) quero selecionar as mesmas!</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" height="246" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 472px; height: 219px;"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="75"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Dia</SPAN></TD><TD style="border: 0px black; border-image: none;" width="85"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Entrada</SPAN></TD><TD style="border: 0px black; border-image: none;" width="85"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Saída</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">01/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">02/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 660,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 330,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">03/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 920,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 460,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">04/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 1.180,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 590,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">05/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 1.440,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 720,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">06/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 1.700,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 850,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">07/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 1.960,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 980,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">08/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 2.220,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 1.110,00 </SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Sat, 04 Jul 2015 22:35:26 GMT 2015-07-04T22:35:26Z Controle de Entrada e Saida https://community.qlik.com/t5/Brasil/Controle-de-Entrada-e-Saida/m-p/883514#M29338 <HTML><HEAD></HEAD><BODY><P>Estou criando um controle de entrada e saída para um trabalho no meu curso, estou iniciando e começo muito pouco. Poderiam me ajudar, Realizei a importação da minha planilha para a ferramenta Qlik Qual dessas opções eu consigo abrir as informações que foram importadas.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/91889_pastedImage_1.png" /></P><P>OBS: Tenho três colunas (Data, Entrada e Saída) quero selecionar as mesmas!</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" height="246" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 472px; height: 219px;"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="75"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Dia</SPAN></TD><TD style="border: 0px black; border-image: none;" width="85"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Entrada</SPAN></TD><TD style="border: 0px black; border-image: none;" width="85"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Saída</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">01/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">02/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 660,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 330,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">03/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 920,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 460,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">04/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 1.180,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 590,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">05/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 1.440,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 720,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">06/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 1.700,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 850,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">07/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 1.960,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 980,00 </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">08/01/2014</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 2.220,00 </SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> R$&nbsp;&nbsp; 1.110,00 </SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Sat, 04 Jul 2015 22:35:26 GMT https://community.qlik.com/t5/Brasil/Controle-de-Entrada-e-Saida/m-p/883514#M29338 2015-07-04T22:35:26Z Re: Controle de Entrada e Saida https://community.qlik.com/t5/Brasil/Controle-de-Entrada-e-Saida/m-p/883515#M29339 <HTML><HEAD></HEAD><BODY><P>Comecei a procurar como fazer e descobri, Obrigado a todos!</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/91892_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Sat, 04 Jul 2015 22:59:53 GMT https://community.qlik.com/t5/Brasil/Controle-de-Entrada-e-Saida/m-p/883515#M29339 2015-07-04T22:59:53Z