topic Re: expression showing error. please help? in QlikView https://community.qlik.com/t5/QlikView/expression-showing-error-please-help/m-p/949409#M968136 <HTML><HEAD></HEAD><BODY><P>May be it with set analysis:</P><P></P><P><STRONG>=Count(DISTINT {&lt;Queue -= {'bg', 'hg', 'hy'}&gt;} ClientID)</STRONG></P></BODY></HTML> Mon, 28 Sep 2015 12:00:46 GMT sunny_talwar 2015-09-28T12:00:46Z expression showing error. please help? https://community.qlik.com/t5/QlikView/expression-showing-error-please-help/m-p/949406#M968133 <HTML><HEAD></HEAD><BODY><P><BR />hi,</P><P></P><P>I have used below expression but it is showing error? how to set this to correct?</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">COUNT</SPAN><STRONG style=": ; color: #ff0000; font-size: 8pt;">(</STRONG><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NOT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MATCH</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Queue</SPAN><SPAN style="font-size: 8pt;">,'bg','hg','hy'),</SPAN><SPAN style="color: #800000; font-size: 8pt;">ClientID</SPAN><SPAN style="font-size: 8pt;">)</SPAN></P><P> </P><P></P><P></P></BODY></HTML> Mon, 28 Sep 2015 11:47:51 GMT https://community.qlik.com/t5/QlikView/expression-showing-error-please-help/m-p/949406#M968133 2015-09-28T11:47:51Z Re: expression showing error. please help? https://community.qlik.com/t5/QlikView/expression-showing-error-please-help/m-p/949407#M968134 <HTML><HEAD></HEAD><BODY><P>You have 3 (´s and only 2 )´s please check this</P></BODY></HTML> Mon, 28 Sep 2015 11:49:41 GMT https://community.qlik.com/t5/QlikView/expression-showing-error-please-help/m-p/949407#M968134 Clever_Anjos 2015-09-28T11:49:41Z Re: expression showing error. please help? https://community.qlik.com/t5/QlikView/expression-showing-error-please-help/m-p/949408#M968135 <HTML><HEAD></HEAD><BODY><P>Try This:</P><P></P><P><STRONG>​COUNT(DISTINCT IF(NOT MATCH(Queue,'bg','hg','hy')),ClientID)</STRONG></P></BODY></HTML> Mon, 28 Sep 2015 11:58:23 GMT https://community.qlik.com/t5/QlikView/expression-showing-error-please-help/m-p/949408#M968135 nagarjuna_kotha 2015-09-28T11:58:23Z Re: expression showing error. please help? https://community.qlik.com/t5/QlikView/expression-showing-error-please-help/m-p/949409#M968136 <HTML><HEAD></HEAD><BODY><P>May be it with set analysis:</P><P></P><P><STRONG>=Count(DISTINT {&lt;Queue -= {'bg', 'hg', 'hy'}&gt;} ClientID)</STRONG></P></BODY></HTML> Mon, 28 Sep 2015 12:00:46 GMT https://community.qlik.com/t5/QlikView/expression-showing-error-please-help/m-p/949409#M968136 sunny_talwar 2015-09-28T12:00:46Z