topic Re: Dúvida Urgente in Brasil https://community.qlik.com/t5/Brasil/D%C3%BAvida-Urgente/m-p/392138#M10852 <HTML><HEAD></HEAD><BODY><P>Yuri, obrigado por ajudar, teria email para eu entrar em contato com vc para me explicar melhor?? </P></BODY></HTML> Mon, 08 Oct 2012 17:35:53 GMT 2012-10-08T17:35:53Z Dúvida Urgente https://community.qlik.com/t5/Brasil/D%C3%BAvida-Urgente/m-p/392136#M10850 <HTML><HEAD></HEAD><BODY><P>Boa tarde,</P><P>minha dúvida é a seguinte, tenho uma planilha onde é preenchido por exemplo o codigo de um filme o nome dele e o mes no qual ele n deve aparecer as vendas, exemplo:</P><P></P><P></P><P>cod&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Nome_fillme&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Data</P><P>0000001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A era do gelo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08/07/2011</P><P></P><P></P><P></P><P>Eu tenho uma planilha preenchida nesse formato, eu tenho q fazer com q o relatório me mostre as vendas do filme a era do gelo de todos os anos, porem qndo chegar em Julho de 2011, ele n me mostre venda nenhuma ou seja eu quero que o relatório não me mostre as vendas dos meses e anos que eu tenho na planilha..</P><P></P><P>No aguardo, qualquer dúvida por favor perguntem.</P></BODY></HTML> Mon, 08 Oct 2012 16:45:22 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-Urgente/m-p/392136#M10850 2012-10-08T16:45:22Z Re: Dúvida Urgente https://community.qlik.com/t5/Brasil/D%C3%BAvida-Urgente/m-p/392137#M10851 <HTML><HEAD></HEAD><BODY><P>Basta utilizar o Not Exists.</P><P></P><P>Da uma olhada no exemplo:</P><P></P><P>Locacao_Tmp:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Locacao.FILME,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Locacao.DATA</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/01/2012</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/01/2012</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/01/2012</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02/01/2012</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02/01/2012</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02/01/2012</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;D,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02/01/2012</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/02/2012</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/02/2012</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/02/2012</P><P>];</P><P></P><P></P><P>Nao_Visualizar:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Nao_Visualizar.FILME&amp;Nao_Visualizar.DATA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;as Nao_Visualizar.CHAVE,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Nao_Visualizar.FILME,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Nao_Visualizar.DATA;</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Nao_Visualizar.FILME,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Nao_Visualizar.DATA</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/01/2012 </P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/01/2012</P><P>];</P><P></P><P></P><P>Locacao:</P><P>NoConcatenate</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Locacao.FILME, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Locacao.DATA</P><P>RESIDENT Locacao_Tmp</P><P>WHERE </P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NOT Exists(Nao_Visualizar.CHAVE,Locacao.FILME&amp;Locacao.DATA);</P><P></P><P></P><P></P><P></P><P>DROP TABLE Locacao_Tmp;</P></BODY></HTML> Mon, 08 Oct 2012 17:22:14 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-Urgente/m-p/392137#M10851 nicolett_yuri 2012-10-08T17:22:14Z Re: Dúvida Urgente https://community.qlik.com/t5/Brasil/D%C3%BAvida-Urgente/m-p/392138#M10852 <HTML><HEAD></HEAD><BODY><P>Yuri, obrigado por ajudar, teria email para eu entrar em contato com vc para me explicar melhor?? </P></BODY></HTML> Mon, 08 Oct 2012 17:35:53 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-Urgente/m-p/392138#M10852 2012-10-08T17:35:53Z