topic Expression not showing values? in QlikView https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/663020#M1062050 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data with below</P><P></P><P>Dimension: EmployeeName</P><P>Expression: =If(MixMatch(Outcome='Update',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Updated to All',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Updated to Outstanding'),Count(ID))</P><P></P><P>But the data is showing blank values under expression as there is data in the database. can anyone please suggest me is there any error in expression?</P></BODY></HTML> Mon, 22 Sep 2014 14:08:17 GMT 2014-09-22T14:08:17Z Expression not showing values? https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/663020#M1062050 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data with below</P><P></P><P>Dimension: EmployeeName</P><P>Expression: =If(MixMatch(Outcome='Update',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Updated to All',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Updated to Outstanding'),Count(ID))</P><P></P><P>But the data is showing blank values under expression as there is data in the database. can anyone please suggest me is there any error in expression?</P></BODY></HTML> Mon, 22 Sep 2014 14:08:17 GMT https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/663020#M1062050 2014-09-22T14:08:17Z Re: Expression not showing values? https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/663021#M1062051 <HTML><HEAD></HEAD><BODY><P>I think</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">Outcome='Update'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; is true or false --&gt; -1 or 0</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">MixMatch(-1/0, .........)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; always 0</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">Count(ID)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; never<BR /></SPAN></P></BODY></HTML> Tue, 23 Sep 2014 00:17:37 GMT https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/663021#M1062051 maxgro 2014-09-23T00:17:37Z Re: Expression not showing values? https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/663022#M1062052 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>Count(If(MixMatch(Outcome,'Update','Update to All','Updated to Outstanding'),ID)</P></BODY></HTML> Tue, 23 Sep 2014 00:30:32 GMT https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/663022#M1062052 nagaiank 2014-09-23T00:30:32Z