topic Re: Expressão Count comparando dois campos in QlikView https://community.qlik.com/t5/QlikView/Express%C3%A3o-Count-comparando-dois-campos/m-p/964155#M959875 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IF(Negocio &lt;&gt; Negocio1,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Mês </SPAN>)</SPAN></P></BODY></HTML> Mon, 26 Oct 2015 20:25:23 GMT Anonymous 2015-10-26T20:25:23Z Expressão Count comparando dois campos https://community.qlik.com/t5/QlikView/Express%C3%A3o-Count-comparando-dois-campos/m-p/964153#M959873 <HTML><HEAD></HEAD><BODY><P>Olá.. estou começando agora a trabalhar com QlikView e estou com uma dúvida, acho que é bem boba mas se puderem me ajudar ficarei muito grato.</P><P></P><P>Criei uma tabela parecida com o exemplo abaixo:</P><P></P><P>Mês&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Nome&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Negócio&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NegócioX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>jan/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp; </P><P>jan/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y</P><P>fev/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y</P><P>fev/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp; </P><P></P><P>Queria montar uma expressão que contasse quantas vezes (dentro de cada mês) o campo [Negócio] é diferente do campo [NegócioX].</P><P></P><P>Obrigado!</P></BODY></HTML> Mon, 26 Oct 2015 18:39:33 GMT https://community.qlik.com/t5/QlikView/Express%C3%A3o-Count-comparando-dois-campos/m-p/964153#M959873 2015-10-26T18:39:33Z Re: Expressão Count comparando dois campos https://community.qlik.com/t5/QlikView/Express%C3%A3o-Count-comparando-dois-campos/m-p/964154#M959874 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>SUM(IF(Negocio &lt;&gt; Negocio1,1,0))</P></BODY></HTML> Mon, 26 Oct 2015 19:42:26 GMT https://community.qlik.com/t5/QlikView/Express%C3%A3o-Count-comparando-dois-campos/m-p/964154#M959874 Clever_Anjos 2015-10-26T19:42:26Z Re: Expressão Count comparando dois campos https://community.qlik.com/t5/QlikView/Express%C3%A3o-Count-comparando-dois-campos/m-p/964155#M959875 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IF(Negocio &lt;&gt; Negocio1,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Mês </SPAN>)</SPAN></P></BODY></HTML> Mon, 26 Oct 2015 20:25:23 GMT https://community.qlik.com/t5/QlikView/Express%C3%A3o-Count-comparando-dois-campos/m-p/964155#M959875 Anonymous 2015-10-26T20:25:23Z