topic Re: Count expression result and table output not matching in QlikView https://community.qlik.com/t5/QlikView/Count-expression-result-and-table-output-not-matching/m-p/1286904#M402844 <HTML><HEAD></HEAD><BODY><P>some of your Result may have values greater than 1 thats why the difference in output.</P><P></P><P>But your comparison to count vs sum is not correct.&nbsp; </P><P>it should always be count vs count or sum vs sum, so change your straight table expression to the same as what you used in the text box</P></BODY></HTML> Tue, 06 Dec 2016 10:37:52 GMT vinieme12 2016-12-06T10:37:52Z Count expression result and table output not matching https://community.qlik.com/t5/QlikView/Count-expression-result-and-table-output-not-matching/m-p/1286902#M402842 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I am trying to display the count of Results in a textbox in the main dashboard and have a straight table which shows the details about this count.</P><P>The count on the textbox and that in the straight table is not matching.</P><P>Expression used in the textbox = count({&lt;[Parameter Grouping] = 'Microbiological'&gt;}Result)</P><P>Expression used in straight table = sum(Result) [I have unchecked Suppress zero values and select 'Microbiological' as the filter]</P><P></P><P>Count on text box = 8,591 and Count in straight table = 12,006</P><P></P><P>Can you help me understand what could be wrong with this?</P></BODY></HTML> Tue, 06 Dec 2016 09:44:48 GMT https://community.qlik.com/t5/QlikView/Count-expression-result-and-table-output-not-matching/m-p/1286902#M402842 mugdhaojha 2016-12-06T09:44:48Z Re: Count expression result and table output not matching https://community.qlik.com/t5/QlikView/Count-expression-result-and-table-output-not-matching/m-p/1286903#M402843 <HTML><HEAD></HEAD><BODY><P>Check the expression in straight table:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">= <SPAN style="text-decoration: line-through;">sum</SPAN>Count(Result)</SPAN></P></BODY></HTML> Tue, 06 Dec 2016 10:16:00 GMT https://community.qlik.com/t5/QlikView/Count-expression-result-and-table-output-not-matching/m-p/1286903#M402843 MindaugasBacius 2016-12-06T10:16:00Z Re: Count expression result and table output not matching https://community.qlik.com/t5/QlikView/Count-expression-result-and-table-output-not-matching/m-p/1286904#M402844 <HTML><HEAD></HEAD><BODY><P>some of your Result may have values greater than 1 thats why the difference in output.</P><P></P><P>But your comparison to count vs sum is not correct.&nbsp; </P><P>it should always be count vs count or sum vs sum, so change your straight table expression to the same as what you used in the text box</P></BODY></HTML> Tue, 06 Dec 2016 10:37:52 GMT https://community.qlik.com/t5/QlikView/Count-expression-result-and-table-output-not-matching/m-p/1286904#M402844 vinieme12 2016-12-06T10:37:52Z