topic Campo com delimitador in Brasil https://community.qlik.com/t5/Brasil/Campo-com-delimitador/m-p/1160273#M40759 <HTML><HEAD></HEAD><BODY><P>Bom dia , estou com uma dúvida. </P><P>Tenho uma tabela no qlik que esta assim : </P><P></P><P>Item,cod, desc</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , teste</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , teste1</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , teste2</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,testesss&nbsp; </P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,testes555</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,006&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,testes456</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,testes4455</P><P></P><P>quero criar uma nova tabela mas dessa forma : </P><P></P><P>Item&nbsp;&nbsp; Cod&nbsp;&nbsp;&nbsp; desc </P><P>1,001 - Teste ; 002 - Teste1;003 - Teste2</P><P>2,004 - <SPAN style="font-size: 13.3333px;">testesss;005 - <SPAN style="font-size: 13.3333px;">testes555;006 - <SPAN style="font-size: 13.3333px;">testes456; 007 - <SPAN style="font-size: 13.3333px;">testes4455</SPAN></SPAN></SPAN></SPAN></P><P></P><P></P><P>Podem me ajudar?</P></BODY></HTML> Tue, 17 May 2016 11:04:18 GMT maiconmello 2016-05-17T11:04:18Z Campo com delimitador https://community.qlik.com/t5/Brasil/Campo-com-delimitador/m-p/1160273#M40759 <HTML><HEAD></HEAD><BODY><P>Bom dia , estou com uma dúvida. </P><P>Tenho uma tabela no qlik que esta assim : </P><P></P><P>Item,cod, desc</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , teste</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , teste1</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , teste2</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,testesss&nbsp; </P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,testes555</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,006&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,testes456</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,testes4455</P><P></P><P>quero criar uma nova tabela mas dessa forma : </P><P></P><P>Item&nbsp;&nbsp; Cod&nbsp;&nbsp;&nbsp; desc </P><P>1,001 - Teste ; 002 - Teste1;003 - Teste2</P><P>2,004 - <SPAN style="font-size: 13.3333px;">testesss;005 - <SPAN style="font-size: 13.3333px;">testes555;006 - <SPAN style="font-size: 13.3333px;">testes456; 007 - <SPAN style="font-size: 13.3333px;">testes4455</SPAN></SPAN></SPAN></SPAN></P><P></P><P></P><P>Podem me ajudar?</P></BODY></HTML> Tue, 17 May 2016 11:04:18 GMT https://community.qlik.com/t5/Brasil/Campo-com-delimitador/m-p/1160273#M40759 maiconmello 2016-05-17T11:04:18Z Re: Campo com delimitador https://community.qlik.com/t5/Brasil/Campo-com-delimitador/m-p/1160274#M40760 <HTML><HEAD></HEAD><BODY><P>Tente</P><UL><LI>Grafico Tipo Tabela Simples</LI><LI>Adicione Item como Expressão</LI><LI>Adicione Concat (distinct cod &amp; '-' &amp; desc, ';') as Expressão</LI></UL></BODY></HTML> Tue, 17 May 2016 11:36:19 GMT https://community.qlik.com/t5/Brasil/Campo-com-delimitador/m-p/1160274#M40760 Clever_Anjos 2016-05-17T11:36:19Z