topic Contar valores in QlikView https://community.qlik.com/t5/QlikView/Contar-valores/m-p/1223001#M390789 <HTML><HEAD></HEAD><BODY><P>Bom dia, pessoal!</P><P></P><P>Sou muito novo no mundo do BI e se vocês pudessem me ajudar com algumas dúvidas que estão surgindo, eu ficaria muito agradecido.</P><P></P><P>Eu usei dois arquivos para importar dados para o Qlik, depois criei dois objetos gráficos do tipo tabela. minha dúvida é a seguinte em uma das tabelas eu preciso contar quantos registros eu tenho na outra dada três condições. Eu usei o "count", usei também o "count" com "if", mas o resultado retornado é sempre a quantidades de itens resultantes do filtro da outra tabela.</P><P></P><P>Vou ver se consigo exemplificar.</P><P></P><P>Tabela 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tabela 2</P><P>Item 1 | Item 2 | Item 3 | Item 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item 1.1 | Item 2.1 | Item 3.1</P><P>aaa&nbsp;&nbsp;&nbsp;&nbsp; | 111&nbsp;&nbsp;&nbsp;&nbsp; | 222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aaa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>bbb&nbsp;&nbsp;&nbsp;&nbsp; | 222&nbsp;&nbsp;&nbsp;&nbsp; | 333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bbb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 000</P><P>aaa&nbsp;&nbsp;&nbsp;&nbsp; | 111&nbsp;&nbsp;&nbsp;&nbsp; | 333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aaa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 000</P><P>ddd&nbsp;&nbsp;&nbsp;&nbsp; | 444&nbsp;&nbsp;&nbsp;&nbsp; | 333&nbsp;&nbsp;&nbsp;&nbsp; | ?</P><P>aaa&nbsp;&nbsp;&nbsp;&nbsp; | 222&nbsp;&nbsp;&nbsp;&nbsp; | 444&nbsp;&nbsp;&nbsp;&nbsp; | ?</P><P></P><P>Nesse caso a coluna "Item 4" é calculada, e precisa retornar o valor da contagem feita na tabela 2, condicionada as colunas 1 e 2 da tabela 1. nesse caso a linha 1 receberia 2, a linha 5 retornaria 0 e etc.</P><P></P><P>Obrigado!</P></BODY></HTML> Thu, 24 Nov 2016 13:41:04 GMT 2016-11-24T13:41:04Z Contar valores https://community.qlik.com/t5/QlikView/Contar-valores/m-p/1223001#M390789 <HTML><HEAD></HEAD><BODY><P>Bom dia, pessoal!</P><P></P><P>Sou muito novo no mundo do BI e se vocês pudessem me ajudar com algumas dúvidas que estão surgindo, eu ficaria muito agradecido.</P><P></P><P>Eu usei dois arquivos para importar dados para o Qlik, depois criei dois objetos gráficos do tipo tabela. minha dúvida é a seguinte em uma das tabelas eu preciso contar quantos registros eu tenho na outra dada três condições. Eu usei o "count", usei também o "count" com "if", mas o resultado retornado é sempre a quantidades de itens resultantes do filtro da outra tabela.</P><P></P><P>Vou ver se consigo exemplificar.</P><P></P><P>Tabela 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tabela 2</P><P>Item 1 | Item 2 | Item 3 | Item 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item 1.1 | Item 2.1 | Item 3.1</P><P>aaa&nbsp;&nbsp;&nbsp;&nbsp; | 111&nbsp;&nbsp;&nbsp;&nbsp; | 222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aaa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>bbb&nbsp;&nbsp;&nbsp;&nbsp; | 222&nbsp;&nbsp;&nbsp;&nbsp; | 333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bbb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 000</P><P>aaa&nbsp;&nbsp;&nbsp;&nbsp; | 111&nbsp;&nbsp;&nbsp;&nbsp; | 333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aaa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 000</P><P>ddd&nbsp;&nbsp;&nbsp;&nbsp; | 444&nbsp;&nbsp;&nbsp;&nbsp; | 333&nbsp;&nbsp;&nbsp;&nbsp; | ?</P><P>aaa&nbsp;&nbsp;&nbsp;&nbsp; | 222&nbsp;&nbsp;&nbsp;&nbsp; | 444&nbsp;&nbsp;&nbsp;&nbsp; | ?</P><P></P><P>Nesse caso a coluna "Item 4" é calculada, e precisa retornar o valor da contagem feita na tabela 2, condicionada as colunas 1 e 2 da tabela 1. nesse caso a linha 1 receberia 2, a linha 5 retornaria 0 e etc.</P><P></P><P>Obrigado!</P></BODY></HTML> Thu, 24 Nov 2016 13:41:04 GMT https://community.qlik.com/t5/QlikView/Contar-valores/m-p/1223001#M390789 2016-11-24T13:41:04Z Re: Contar valores https://community.qlik.com/t5/QlikView/Contar-valores/m-p/1223002#M390790 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Oi Josemar, isto é probalby possível, mas você poderia compartilhar um qvw com alguns dados de amostra? Seu exemplo ainda não apareceu corretamente, por isso é difícil descobrir exatamente o que você quer!</SPAN></P></BODY></HTML> Thu, 24 Nov 2016 15:15:56 GMT https://community.qlik.com/t5/QlikView/Contar-valores/m-p/1223002#M390790 adamdavi3s 2016-11-24T15:15:56Z