topic Conditional Total in QlikView https://community.qlik.com/t5/QlikView/Conditional-Total/m-p/304043#M1192949 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-GB" style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">I have below table showing Invoice data against Customer ID.</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 330px;"><TBODY><TR><TD class="xl74" height="61" width="83">Customer ID</TD><TD class="xl75" style="border-left: medium none;" width="73">Invoice No</TD><TD class="xl75" style="border-left: medium none;" width="92">Invoice Value</TD><TD class="xl76" style="border-left: medium none;" width="82">PAID?</TD></TR><TR><TD class="xl71" height="20">ABC</TD><TD class="xl72" style="border-left: medium none;">11</TD><TD class="xl72" style="border-left: medium none;">125</TD><TD class="xl73" style="border-left: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">PQR</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">12</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">130</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">DEF</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">13</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">140</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">GHI</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">14</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">155</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">JKL</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">15</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">146</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">16</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">128</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">XYZ</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">17</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">99</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="21" style="border-top: medium none;">MNO</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">18</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">100</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">PQR</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">19</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">135</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">XYZ</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">20</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">198</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">PQR</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">21</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">197</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">22</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">210</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">DEF</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">23</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">150</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">GHI</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">24</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">95</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl68" height="21" style="border-top: medium none;">JKL</TD><TD class="xl69" style="border-left: medium none; border-top: medium none;">25</TD><TD class="xl69" style="border-left: medium none; border-top: medium none;">50</TD><TD class="xl70" style="border-left: medium none; border-top: medium none;">NO</TD></TR></TBODY></TABLE><P></P><P><SPAN lang="EN-GB" style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">I want to get total value of unpaid invoices against each Customer ID.</SPAN></P><P><SPAN lang="EN-GB" style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Can someone please give me script?</SPAN></P><P><SPAN lang="EN-GB" style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">The result should be as below</SPAN></P><P><SPAN lang="EN-GB" style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="142"><TBODY><TR><TD class="xl71" height="61" width="78">Customer ID</TD><TD class="xl72" style="border-left: medium none;" width="64">Invoice Value Not Paid</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">ABC</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">125</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">DEF</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">150</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">GHI</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">95</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">JKL</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">50</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">MNO</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">100</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">PQR</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">265</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">XYZ</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">297</TD></TR><TR><TD class="xl69" height="21" style="border-top: medium none;">TOTAL</TD><TD class="xl70" style="border-left: medium none; border-top: medium none;">1082</TD></TR></TBODY></TABLE><P><BR />Thaks in advance.</P></BODY></HTML> Mon, 25 Jul 2011 11:39:25 GMT 2011-07-25T11:39:25Z Conditional Total https://community.qlik.com/t5/QlikView/Conditional-Total/m-p/304043#M1192949 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-GB" style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">I have below table showing Invoice data against Customer ID.</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 330px;"><TBODY><TR><TD class="xl74" height="61" width="83">Customer ID</TD><TD class="xl75" style="border-left: medium none;" width="73">Invoice No</TD><TD class="xl75" style="border-left: medium none;" width="92">Invoice Value</TD><TD class="xl76" style="border-left: medium none;" width="82">PAID?</TD></TR><TR><TD class="xl71" height="20">ABC</TD><TD class="xl72" style="border-left: medium none;">11</TD><TD class="xl72" style="border-left: medium none;">125</TD><TD class="xl73" style="border-left: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">PQR</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">12</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">130</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">DEF</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">13</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">140</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">GHI</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">14</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">155</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">JKL</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">15</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">146</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">16</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">128</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">XYZ</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">17</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">99</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="21" style="border-top: medium none;">MNO</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">18</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">100</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">PQR</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">19</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">135</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">XYZ</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">20</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">198</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">PQR</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">21</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">197</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">22</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">210</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">YES</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">DEF</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">23</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">150</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">GHI</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">24</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">95</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">NO</TD></TR><TR><TD class="xl68" height="21" style="border-top: medium none;">JKL</TD><TD class="xl69" style="border-left: medium none; border-top: medium none;">25</TD><TD class="xl69" style="border-left: medium none; border-top: medium none;">50</TD><TD class="xl70" style="border-left: medium none; border-top: medium none;">NO</TD></TR></TBODY></TABLE><P></P><P><SPAN lang="EN-GB" style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">I want to get total value of unpaid invoices against each Customer ID.</SPAN></P><P><SPAN lang="EN-GB" style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Can someone please give me script?</SPAN></P><P><SPAN lang="EN-GB" style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">The result should be as below</SPAN></P><P><SPAN lang="EN-GB" style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="142"><TBODY><TR><TD class="xl71" height="61" width="78">Customer ID</TD><TD class="xl72" style="border-left: medium none;" width="64">Invoice Value Not Paid</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">ABC</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">125</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">DEF</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">150</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">GHI</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">95</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">JKL</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">50</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">MNO</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">100</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">PQR</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">265</TD></TR><TR><TD class="xl67" height="20" style="border-top: medium none;">XYZ</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">297</TD></TR><TR><TD class="xl69" height="21" style="border-top: medium none;">TOTAL</TD><TD class="xl70" style="border-left: medium none; border-top: medium none;">1082</TD></TR></TBODY></TABLE><P><BR />Thaks in advance.</P></BODY></HTML> Mon, 25 Jul 2011 11:39:25 GMT https://community.qlik.com/t5/QlikView/Conditional-Total/m-p/304043#M1192949 2011-07-25T11:39:25Z Conditional Total https://community.qlik.com/t5/QlikView/Conditional-Total/m-p/304044#M1192951 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use customer ID as dimension and as expression</P><P>=sum({&lt;[PAID?]={'NO'}&gt;} [Invoice Value])</P><P></P><P>assuming that Invoice Value, PAID? are your field names.</P><P></P><P>Stefan</P></BODY></HTML> Mon, 25 Jul 2011 11:42:30 GMT https://community.qlik.com/t5/QlikView/Conditional-Total/m-p/304044#M1192951 swuehl 2011-07-25T11:42:30Z Conditional Total https://community.qlik.com/t5/QlikView/Conditional-Total/m-p/304045#M1192953 <HTML><HEAD></HEAD><BODY><P> Thanks for your quick response. It's Working fine.</P></BODY></HTML> Mon, 25 Jul 2011 12:21:47 GMT https://community.qlik.com/t5/QlikView/Conditional-Total/m-p/304045#M1192953 2011-07-25T12:21:47Z