topic Re: Quebrar tabela in Brasil https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698047#M20486 <HTML><HEAD></HEAD><BODY><P>Boa tarde.</P><P>Veja se isso atende.</P></BODY></HTML> Thu, 25 Sep 2014 20:35:29 GMT lucianosv 2014-09-25T20:35:29Z Quebrar tabela https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698046#M20485 <HTML><HEAD></HEAD><BODY><P>Pessoal,</P><P></P><P></P><P></P><P>tenho uma tabela que um campo&nbsp; o outro ( seria uma hierarquia definida)<BR />Preciso quebrar e transformar tudo em uma linha&nbsp; estou anexando o Qvw de exemplo para vocês entenderem, tomem base o campo relacionamento</P></BODY></HTML> Thu, 25 Sep 2014 15:13:42 GMT https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698046#M20485 2014-09-25T15:13:42Z Re: Quebrar tabela https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698047#M20486 <HTML><HEAD></HEAD><BODY><P>Boa tarde.</P><P>Veja se isso atende.</P></BODY></HTML> Thu, 25 Sep 2014 20:35:29 GMT https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698047#M20486 lucianosv 2014-09-25T20:35:29Z Re: Quebrar tabela https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698048#M20487 <HTML><HEAD></HEAD><BODY><P>Quase isso amigo, preciso formar uma unica linha com&nbsp; entende?</P><P>Tipo o Campo_2 Tras o 3, mas ao selecionar o 2 tinha que trazer hierarquia toda até o 6 ou 5</P></BODY></HTML> Fri, 26 Sep 2014 16:25:01 GMT https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698048#M20487 2014-09-26T16:25:01Z Re: Quebrar tabela https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698049#M20488 <HTML><HEAD></HEAD><BODY><P>Já testou o comando Hierarchy?</P><P></P><P>Me explica certinho o que você precisa.</P></BODY></HTML> Fri, 26 Sep 2014 17:16:32 GMT https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698049#M20488 nicolett_yuri 2014-09-26T17:16:32Z Re: Quebrar tabela https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698050#M20489 <HTML><HEAD></HEAD><BODY><P>Boa noite.</P><P></P><P>Pelo o que eu entendi, segue um exemplo e o modelo.&nbsp; Espero que ajude.</P><P></P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Dados</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Descrição</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Relacionamento1</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Descrição2</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Relacionamento2</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Descrição3</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Relacionamento3</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Descrição4</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Relacionamento4</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Descrição5</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Relacionamento5</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Descrição6</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">AAAAAA</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BBBBBB</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">CCCCCC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DDDDDD</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_5</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EEEEEE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_6</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FFFFFF</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BBBBBB</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">CCCCCC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DDDDDD</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_5</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EEEEEE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_6</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FFFFFF</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">CCCCCC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DDDDDD</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_5</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EEEEEE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_6</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FFFFFF</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DDDDDD</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_5</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EEEEEE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_6</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FFFFFF</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_5</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EEEEEE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_6</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FFFFFF</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Campo_6</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FFFFFF</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD></TR></TBODY></TABLE><P></P><P>Att,</P><P></P><P>Alessandro Furtado</P></BODY></HTML> Sun, 28 Sep 2014 03:25:39 GMT https://community.qlik.com/t5/Brasil/Quebrar-tabela/m-p/698050#M20489 afurtado 2014-09-28T03:25:39Z