topic Count question in QlikView https://community.qlik.com/t5/QlikView/Count-question/m-p/243827#M93067 <HTML><HEAD></HEAD><BODY><P>Dear specialists</P><P></P><P>I need to count the amout of this the stoke of a product in database 1 is different then in database 2.</P><P>I got all the data right now like:</P><P></P><P>Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LocationA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LocationB<BR />0001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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; 1</P><P>0002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>0003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>0004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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; 3</P><P>0005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><P>I need a calculation that counts the times that LocationA &lt;&gt; LocationB, in this case the outcome should be 3</P><P>Any suggestions?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 26 May 2011 14:12:46 GMT Anonymous 2011-05-26T14:12:46Z Count question https://community.qlik.com/t5/QlikView/Count-question/m-p/243827#M93067 <HTML><HEAD></HEAD><BODY><P>Dear specialists</P><P></P><P>I need to count the amout of this the stoke of a product in database 1 is different then in database 2.</P><P>I got all the data right now like:</P><P></P><P>Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LocationA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LocationB<BR />0001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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; 1</P><P>0002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>0003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>0004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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; 3</P><P>0005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><P>I need a calculation that counts the times that LocationA &lt;&gt; LocationB, in this case the outcome should be 3</P><P>Any suggestions?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 26 May 2011 14:12:46 GMT https://community.qlik.com/t5/QlikView/Count-question/m-p/243827#M93067 Anonymous 2011-05-26T14:12:46Z Re: Count question https://community.qlik.com/t5/QlikView/Count-question/m-p/243828#M93068 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Try&nbsp;&nbsp;&nbsp;&nbsp; Sum(if(LocationA &lt;&gt; LocationB, 1, 0) )</P></BODY></HTML> Thu, 26 May 2011 14:20:18 GMT https://community.qlik.com/t5/QlikView/Count-question/m-p/243828#M93068 2011-05-26T14:20:18Z Re: Count question https://community.qlik.com/t5/QlikView/Count-question/m-p/243829#M93069 <HTML><HEAD></HEAD><BODY><P>a.medina's method works.</P><P></P><P>Please see attached document. I also did this another way by loading&nbsp; a new column name and just differentiating between the 2 conditions</P><P></P><P></P><P>Cheers,</P><P>Byron</P></BODY></HTML> Thu, 26 May 2011 15:02:50 GMT https://community.qlik.com/t5/QlikView/Count-question/m-p/243829#M93069 2011-05-26T15:02:50Z Count question https://community.qlik.com/t5/QlikView/Count-question/m-p/243830#M93070 <HTML><HEAD></HEAD><BODY><P>Thanks and Thanks, that was what I needed.</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/plus.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/plus.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/plus.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/plus.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/plus.png" /></P></BODY></HTML> Thu, 26 May 2011 17:54:30 GMT https://community.qlik.com/t5/QlikView/Count-question/m-p/243830#M93070 Anonymous 2011-05-26T17:54:30Z