topic Do not load zero values in QlikView https://community.qlik.com/t5/QlikView/Do-not-load-zero-values/m-p/318605#M1198444 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have loaded a full account extract into QV. Four of the fields that I want to use in a transactional sheet are</P><OL><LI>Number of Purchases for the cycle</LI><LI>Value of Purchases for the cycle</LI><LI>Number of Paymentsfor the cycle</LI><LI>Value of Paymentsfor the cycle</LI></OL><P>I then add them in list boxes, with a purchase summary box, payments summary box.</P><P>My problem is that when someone did not make a purchase/payment it is displayed as R0.00, but the summary box obviously still counts it (in total count), so for both purchases and payments it now shows the total amount of customers on our books, as opposed to the total amount of purchases and payments.</P><P>What should I do if I want the total count to not include zeroes?</P></BODY></HTML> Thu, 07 Apr 2011 13:30:49 GMT gerhardl 2011-04-07T13:30:49Z Do not load zero values https://community.qlik.com/t5/QlikView/Do-not-load-zero-values/m-p/318605#M1198444 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have loaded a full account extract into QV. Four of the fields that I want to use in a transactional sheet are</P><OL><LI>Number of Purchases for the cycle</LI><LI>Value of Purchases for the cycle</LI><LI>Number of Paymentsfor the cycle</LI><LI>Value of Paymentsfor the cycle</LI></OL><P>I then add them in list boxes, with a purchase summary box, payments summary box.</P><P>My problem is that when someone did not make a purchase/payment it is displayed as R0.00, but the summary box obviously still counts it (in total count), so for both purchases and payments it now shows the total amount of customers on our books, as opposed to the total amount of purchases and payments.</P><P>What should I do if I want the total count to not include zeroes?</P></BODY></HTML> Thu, 07 Apr 2011 13:30:49 GMT https://community.qlik.com/t5/QlikView/Do-not-load-zero-values/m-p/318605#M1198444 gerhardl 2011-04-07T13:30:49Z Do not load zero values https://community.qlik.com/t5/QlikView/Do-not-load-zero-values/m-p/318606#M1198446 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can you not just use an if statement in your expression to say only count if the field value is &lt;&gt; 0?</P></BODY></HTML> Thu, 07 Apr 2011 14:14:17 GMT https://community.qlik.com/t5/QlikView/Do-not-load-zero-values/m-p/318606#M1198446 2011-04-07T14:14:17Z Do not load zero values https://community.qlik.com/t5/QlikView/Do-not-load-zero-values/m-p/318607#M1198448 <HTML><HEAD></HEAD><BODY><P>COUNT(IF(Value &lt;&gt; 0, Customer))</P><P>++<BR />Peter</P></BODY></HTML> Thu, 07 Apr 2011 14:18:22 GMT https://community.qlik.com/t5/QlikView/Do-not-load-zero-values/m-p/318607#M1198448 prieper 2011-04-07T14:18:22Z