https://community.qlik.com/t5/Brasil/Campos-de-linha-como-coluna-na-tabela-din%C3%A2mica/m-p/1008436#M34643 <HTML><HEAD></HEAD><BODY><P>Regimilson, boa noite.</P><P></P><P>Nao sei se te atende</P><P></P><P><IMG alt="2015-10-19 19_53_09.jpg" class="jive-image image-1" src="/legacyfs/online/102491_2015-10-19 19_53_09.jpg" style="height: auto;" /></P></BODY></HTML> Mon, 19 Oct 2015 21:55:59 GMT afurtado 2015-10-19T21:55:59Z https://community.qlik.com/t5/Brasil/Campos-de-linha-como-coluna-na-tabela-din%C3%A2mica/m-p/1008434#M34641 <HTML><HEAD></HEAD><BODY><P>Bom dia!</P><P></P><P>Tenho uma planilha no excel com uma coluna Garagem como nomes das Garagens e outra coluna de nome&nbsp; Status, onde tem as seguinte informações: Adiantado, Atrasado, No horário.</P><P>Quero fazer uma tabela dinâmica com uma coluna da Garagem e outra do Status:</P><P></P><P>Garagem&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count</P><P>Brotas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adiantado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>Barra&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Atrasado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Ondina&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adiantado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>No exemplo que fiz no Qlik, não consigo acumular os dados do Status como coluna, fica da seguinte forma.</P><P></P><P style="font-size: 13.3333px;">Garagem&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count</P><P style="font-size: 13.3333px;">Brotas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adiantado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Atrasado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adiantado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P style="font-size: 13.3333px;">Barra&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adiantado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Atrasado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adiantado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P style="font-size: 13.3333px;">Ondina&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adiantado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Atrasado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adiantado&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P></BODY></HTML> Mon, 19 Oct 2015 14:20:12 GMT https://community.qlik.com/t5/Brasil/Campos-de-linha-como-coluna-na-tabela-din%C3%A2mica/m-p/1008434#M34641 2015-10-19T14:20:12Z https://community.qlik.com/t5/Brasil/Campos-de-linha-como-coluna-na-tabela-din%C3%A2mica/m-p/1008435#M34642 <HTML><HEAD></HEAD><BODY><P>Acredito que seu problema seja resolvido apenas se você ocultar os valores zerados, para isso, vá até a aba apresentação e marque a opção "Ocultar Zeros"</P></BODY></HTML> Mon, 19 Oct 2015 16:10:04 GMT https://community.qlik.com/t5/Brasil/Campos-de-linha-como-coluna-na-tabela-din%C3%A2mica/m-p/1008435#M34642 nicolett_yuri 2015-10-19T16:10:04Z https://community.qlik.com/t5/Brasil/Campos-de-linha-como-coluna-na-tabela-din%C3%A2mica/m-p/1008436#M34643 <HTML><HEAD></HEAD><BODY><P>Regimilson, boa noite.</P><P></P><P>Nao sei se te atende</P><P></P><P><IMG alt="2015-10-19 19_53_09.jpg" class="jive-image image-1" src="/legacyfs/online/102491_2015-10-19 19_53_09.jpg" style="height: auto;" /></P></BODY></HTML> Mon, 19 Oct 2015 21:55:59 GMT https://community.qlik.com/t5/Brasil/Campos-de-linha-como-coluna-na-tabela-din%C3%A2mica/m-p/1008436#M34643 afurtado 2015-10-19T21:55:59Z https://community.qlik.com/t5/Brasil/Campos-de-linha-como-coluna-na-tabela-din%C3%A2mica/m-p/1008437#M34644 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/167037">regimilson</A></P><P>Dua dúvida foi esclarecida?</P><P>Caso sim, favor marcar as respostas que te ajudaram para fechar o tópico <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 21 Oct 2015 10:50:47 GMT https://community.qlik.com/t5/Brasil/Campos-de-linha-como-coluna-na-tabela-din%C3%A2mica/m-p/1008437#M34644 nicolett_yuri 2015-10-21T10:50:47Z