https://community.qlik.com/t5/Reporting-Service-Alerting/Relat%C3%B3rio-analisando-duas-tabelas/m-p/2023807#M478 <P>Bom dia, pessoal!&nbsp;</P> <P>Preciso realizar uma analise dos clientes que não foram visitados. Tenho a relação da base de clientes e a relação dos clientes visitados.&nbsp;</P> <P><STRONG>Como posso automatizar uma tabela que traga apenas os clientes não visitados?&nbsp;</STRONG></P> <TABLE style="border-collapse: collapse; width: 96pt;" border="0" width="128" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD colspan="2" width="128" height="20" class="xl66" style="height: 15.0pt; width: 96pt;"><STRONG>Clientes Visitados</STRONG></TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl67" style="height: 15.0pt; border-top: none;">Cod</TD> <TD class="xl67" style="border-top: none; border-left: none;">Cliente</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">125</TD> <TD class="xl65" style="border-top: none; border-left: none;">João</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">126</TD> <TD class="xl65" style="border-top: none; border-left: none;">Fernanda</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <TABLE style="border-collapse: collapse; width: 96pt;" border="0" width="128" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD colspan="2" width="128" height="20" class="xl64" style="height: 15.0pt; width: 96pt;"><STRONG>Base de clientes</STRONG></TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Cod</TD> <TD class="xl65" style="border-top: none; border-left: none;">Cliente</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">123</TD> <TD class="xl63" style="border-top: none; border-left: none;">Jose</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">124</TD> <TD class="xl63" style="border-top: none; border-left: none;">Maria</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">125</TD> <TD class="xl63" style="border-top: none; border-left: none;">João</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">126</TD> <TD class="xl63" style="border-top: none; border-left: none;">Fernanda</TD> </TR> </TBODY> </TABLE> Fri, 15 Nov 2024 21:52:46 GMT Willianfao70 2024-11-15T21:52:46Z https://community.qlik.com/t5/Reporting-Service-Alerting/Relat%C3%B3rio-analisando-duas-tabelas/m-p/2023807#M478 <P>Bom dia, pessoal!&nbsp;</P> <P>Preciso realizar uma analise dos clientes que não foram visitados. Tenho a relação da base de clientes e a relação dos clientes visitados.&nbsp;</P> <P><STRONG>Como posso automatizar uma tabela que traga apenas os clientes não visitados?&nbsp;</STRONG></P> <TABLE style="border-collapse: collapse; width: 96pt;" border="0" width="128" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD colspan="2" width="128" height="20" class="xl66" style="height: 15.0pt; width: 96pt;"><STRONG>Clientes Visitados</STRONG></TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl67" style="height: 15.0pt; border-top: none;">Cod</TD> <TD class="xl67" style="border-top: none; border-left: none;">Cliente</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">125</TD> <TD class="xl65" style="border-top: none; border-left: none;">João</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">126</TD> <TD class="xl65" style="border-top: none; border-left: none;">Fernanda</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <TABLE style="border-collapse: collapse; width: 96pt;" border="0" width="128" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD colspan="2" width="128" height="20" class="xl64" style="height: 15.0pt; width: 96pt;"><STRONG>Base de clientes</STRONG></TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Cod</TD> <TD class="xl65" style="border-top: none; border-left: none;">Cliente</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">123</TD> <TD class="xl63" style="border-top: none; border-left: none;">Jose</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">124</TD> <TD class="xl63" style="border-top: none; border-left: none;">Maria</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">125</TD> <TD class="xl63" style="border-top: none; border-left: none;">João</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">126</TD> <TD class="xl63" style="border-top: none; border-left: none;">Fernanda</TD> </TR> </TBODY> </TABLE> Fri, 15 Nov 2024 21:52:46 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Relat%C3%B3rio-analisando-duas-tabelas/m-p/2023807#M478 Willianfao70 2024-11-15T21:52:46Z