topic Re: Error in expression Count takes 1 parameter... in QlikView https://community.qlik.com/t5/QlikView/Error-in-expression-Count-takes-1-parameter/m-p/402224#M1160571 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P></P><P><STRONG>if(count(remision)&gt;=2 and (count(distinct idproducto))=1,-1) as "NoMatch2</STRONG></P><P></P><P>And did u use <STRONG>group by</STRONG> too??</P><P></P><P><STRONG>Hope it helps<BR /></STRONG></P></BODY></HTML> Mon, 03 Dec 2012 19:44:28 GMT MayilVahanan 2012-12-03T19:44:28Z Error in expression Count takes 1 parameter... https://community.qlik.com/t5/QlikView/Error-in-expression-Count-takes-1-parameter/m-p/402223#M1160570 <HTML><HEAD></HEAD><BODY><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13545623745116270" jivemacro_uid="_13545623745116270"><P></P><P></P></PRE><P></P><P>Hello;</P><P></P><P>I have an error expression..but I don´t find it...pleae help me on this....tk in advanced. (Maybe is in bold Exp..)</P><P></P><P>Error in expression:<BR />Count takes 1 parameter</P><P>LOAD <BR />remision<BR />,if(count(remision)=1 ,-1)as "NoMatch"<BR />,if(count(remision)&gt;=2,-2)as "SiMatch"<BR />,if(maxstring(idestacion)&lt;&gt;minstring(idestacion),-4) as "DifEstacion"<BR />,if(max(vnatural)&lt;&gt;min(vnatural),-5)as "DifLitros"</P><P>,if(maxstring(idproducto)= minstring(idproducto),-7)as "IgDesc"</P><P>,if(count(remision)&gt;=2 and (maxstring(idproducto)=minstring(idproducto)),-1) as "NoMatch1" <BR /><STRONG>,if(count(remision)&gt;=2 and (count(distinct(idproducto)=1,-1))) as "NoMatch2" </STRONG></P><P></P><P><STRONG>Tk QCommunity!</STRONG></P></BODY></HTML> Mon, 03 Dec 2012 19:30:10 GMT https://community.qlik.com/t5/QlikView/Error-in-expression-Count-takes-1-parameter/m-p/402223#M1160570 jmarinesc 2012-12-03T19:30:10Z Re: Error in expression Count takes 1 parameter... https://community.qlik.com/t5/QlikView/Error-in-expression-Count-takes-1-parameter/m-p/402224#M1160571 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P></P><P><STRONG>if(count(remision)&gt;=2 and (count(distinct idproducto))=1,-1) as "NoMatch2</STRONG></P><P></P><P>And did u use <STRONG>group by</STRONG> too??</P><P></P><P><STRONG>Hope it helps<BR /></STRONG></P></BODY></HTML> Mon, 03 Dec 2012 19:44:28 GMT https://community.qlik.com/t5/QlikView/Error-in-expression-Count-takes-1-parameter/m-p/402224#M1160571 MayilVahanan 2012-12-03T19:44:28Z Re: Error in expression Count takes 1 parameter... https://community.qlik.com/t5/QlikView/Error-in-expression-Count-takes-1-parameter/m-p/402225#M1160572 <HTML><HEAD></HEAD><BODY><P>Tk!&nbsp; </P><P></P><P>It works.. yepppppp!</P></BODY></HTML> Mon, 03 Dec 2012 20:26:16 GMT https://community.qlik.com/t5/QlikView/Error-in-expression-Count-takes-1-parameter/m-p/402225#M1160572 jmarinesc 2012-12-03T20:26:16Z