topic AW:Sum and count not working in QlikView https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171105#M41254 <HTML><HEAD></HEAD><BODY><P>I am preparing an example as the original has sensitive data in it...</P></BODY></HTML> Tue, 01 Dec 2009 22:23:21 GMT agsearle 2009-12-01T22:23:21Z Sum and count not working https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171102#M41251 <HTML><HEAD></HEAD><BODY><P>I have a table of data in a straight table, within which is a column with a balance (ie £200.00).</P><P>This data is then filtered using a series of list boxes, and calculated dimensions to give the result I require.</P><P>I also have a Statistics box to show a total sum of the balance, and a count of rows using the balance column. This column is not a key column.</P><P>The problem I have is that both the sum and counts are wrong? They seem to still show the oringinal sum and count prior to the filtering using the list boxes and calculated dimensions.</P><P>How can I get around this and have the correct totals displayed?</P></BODY></HTML> Tue, 01 Dec 2009 21:59:24 GMT https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171102#M41251 agsearle 2009-12-01T21:59:24Z Sum and count not working https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171103#M41252 <HTML><HEAD></HEAD><BODY><P>can you upload an example, and post the formula you have used in your Sum/Count please?</P><P>listing the dimensions used in your object also.</P></BODY></HTML> Tue, 01 Dec 2009 22:06:23 GMT https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171103#M41252 2009-12-01T22:06:23Z AW:Sum and count not working https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171104#M41253 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>can you upload an example file? There could be many reasons for this behavior.</P><P></P><P>Kind regards.</P><P></P><P></P><P></P></BODY></HTML> Tue, 01 Dec 2009 22:09:36 GMT https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171104#M41253 2009-12-01T22:09:36Z AW:Sum and count not working https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171105#M41254 <HTML><HEAD></HEAD><BODY><P>I am preparing an example as the original has sensitive data in it...</P></BODY></HTML> Tue, 01 Dec 2009 22:23:21 GMT https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171105#M41254 agsearle 2009-12-01T22:23:21Z AW:Sum and count not working https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171106#M41255 <HTML><HEAD></HEAD><BODY><P>I've not been able to reproduce this in a simple example.</P><P>What could possible be going wrong?</P></BODY></HTML> Tue, 01 Dec 2009 22:43:21 GMT https://community.qlik.com/t5/QlikView/Sum-and-count-not-working/m-p/171106#M41255 agsearle 2009-12-01T22:43:21Z