topic Problems with expressions in QlikView https://community.qlik.com/t5/QlikView/Problems-with-expressions/m-p/299310#M1199259 <HTML><HEAD></HEAD><BODY><P>Your Set Analysis syntax is incorrect. Try:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Count ({&lt;[Motivo O] ={'ZWW'}&gt;} DISTINCT [No Order])</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 11 Jan 2011 17:47:51 GMT 2011-01-11T17:47:51Z Problems with expressions https://community.qlik.com/t5/QlikView/Problems-with-expressions/m-p/299309#M1199258 <HTML><HEAD></HEAD><BODY><DIV class="almost_half_cell" id="gt-res-content"><P><STRONG></STRONG></P><DIV class="almost_half_cell" id="gt-suggest" style="display: none;"><STRONG></STRONG></DIV><DIV class="almost_half_cell"><STRONG></STRONG></DIV><DIV class="almost_half_cell"><STRONG><STRONG></STRONG></STRONG></DIV><STRONG>I have</STRONG> a column (field) called [Nº Order] where the appears the order Nº. I have another column (field) called [Reason] where I get the different origins of orders including the value 'ZWW' if the order was placed online. My intention is to count the number of orders placed online.<BR /><BR />By introducing the expression:<BR /><BR /><BR />Count ({} &lt;Motivo O ='ZWW'&gt; DISTINCT [No Order])<BR /><BR />I returned the same as:<BR /><BR /><BR />Count (DISTINCT [No Order])<BR /><BR />And not all orders are online.<BR /><BR />I would appreciate if you can tell me a solution or explanation.<BR /><BR />Thanks!<BR /><BR /></DIV></BODY></HTML> Tue, 11 Jan 2011 17:37:09 GMT https://community.qlik.com/t5/QlikView/Problems-with-expressions/m-p/299309#M1199258 2011-01-11T17:37:09Z Problems with expressions https://community.qlik.com/t5/QlikView/Problems-with-expressions/m-p/299310#M1199259 <HTML><HEAD></HEAD><BODY><P>Your Set Analysis syntax is incorrect. Try:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Count ({&lt;[Motivo O] ={'ZWW'}&gt;} DISTINCT [No Order])</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 11 Jan 2011 17:47:51 GMT https://community.qlik.com/t5/QlikView/Problems-with-expressions/m-p/299310#M1199259 2011-01-11T17:47:51Z Problems with expressions https://community.qlik.com/t5/QlikView/Problems-with-expressions/m-p/299311#M1199260 <HTML><HEAD></HEAD><BODY><P>It works!</P><P></P><P>THANKS!!!</P></BODY></HTML> Tue, 11 Jan 2011 18:02:41 GMT https://community.qlik.com/t5/QlikView/Problems-with-expressions/m-p/299311#M1199260 2011-01-11T18:02:41Z