topic Re: How to change the expression to get pass values in QlikView https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520271#M1126210 <HTML><HEAD></HEAD><BODY><P>If you're getting the same values, I would think you have the same numbers for both Pass and Fail...</P><P></P><P>Have you calculated by hand what it should be?&nbsp; Without knowing what it should be, I can't say whether it is correct or not.</P></BODY></HTML> Mon, 23 Dec 2013 18:56:41 GMT Nicole-Smith 2013-12-23T18:56:41Z How to change the expression to get pass values https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520267#M1126206 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have a expression as below in Straight table</P><P></P><P>count({&lt;Result={'Fail'}&gt;}DISTINCT Reference) so that I will get Number of Failures.</P><P></P><P>If I want to get Number of Pass how can I change the above expression.</P><P></P><P>Could anyone help me.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 23 Dec 2013 16:45:51 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520267#M1126206 2013-12-23T16:45:51Z Re: How to change the expression to get pass values https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520268#M1126207 <HTML><HEAD></HEAD><BODY><P>count({&lt;Result={'Pass'}&gt;}DISTINCT Reference)</P><P></P><P>or</P><P></P><P>count({&lt;Result-={'Fail'}&gt;}DISTINCT Reference)</P></BODY></HTML> Mon, 23 Dec 2013 16:46:38 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520268#M1126207 Nicole-Smith 2013-12-23T16:46:38Z Re: How to change the expression to get pass values https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520269#M1126208 <HTML><HEAD></HEAD><BODY><P>Thanks. I am getting the same figures which is having for Number of Failures. Is this something because of the data in source file or do I need to change anything else?</P></BODY></HTML> Mon, 23 Dec 2013 16:55:40 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520269#M1126208 2013-12-23T16:55:40Z Re: How to change the expression to get pass values https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520270#M1126209 <HTML><HEAD></HEAD><BODY><P>Remove the Distinct from your expression.</P></BODY></HTML> Mon, 23 Dec 2013 17:17:47 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520270#M1126209 iktrayanov 2013-12-23T17:17:47Z Re: How to change the expression to get pass values https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520271#M1126210 <HTML><HEAD></HEAD><BODY><P>If you're getting the same values, I would think you have the same numbers for both Pass and Fail...</P><P></P><P>Have you calculated by hand what it should be?&nbsp; Without knowing what it should be, I can't say whether it is correct or not.</P></BODY></HTML> Mon, 23 Dec 2013 18:56:41 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-expression-to-get-pass-values/m-p/520271#M1126210 Nicole-Smith 2013-12-23T18:56:41Z