topic How to get balance quantity ?? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-balance-quantity/m-p/983#M609439 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P>I have two tables.</P><P></P><P>TABLE1</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 196px;"><TBODY><TR><TD height="20" width="64">PRIORITY</TD><TD width="64">CODE</TD><TD width="68">QNTY</TD></TR><TR><TD align="right" height="20">1</TD><TD>A</TD><TD align="right">10</TD></TR><TR><TD align="right" height="20">1</TD><TD>B</TD><TD align="right">22</TD></TR><TR><TD align="right" height="20">2</TD><TD>A</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">2</TD><TD>B</TD><TD align="right">20</TD></TR><TR><TD align="right" height="20">2</TD><TD>C</TD><TD align="right">10</TD></TR></TBODY></TABLE><P></P><P>TABLE 2</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 105px;"><TBODY><TR><TD class="xl65" height="20" width="64">CODE </TD><TD class="xl65" style="border-left: none;" width="41">TOTAL QNTY</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">25</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">45</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">55</TD></TR></TBODY></TABLE><P></P><P>from above two tables I required below result.</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 586px;"><TBODY><TR><TD height="20" width="64">PRIORITY</TD><TD width="64">CODE</TD><TD width="64">QNTY</TD><TD width="68">AVL QNTY</TD><TD></TD></TR><TR><TD align="right" height="20">1</TD><TD>A</TD><TD align="right">10</TD><TD>25-10 =10</TD><TD>(TOTAL AVL QUNTY IS 25)</TD></TR><TR><TD align="right" height="20">1</TD><TD>B</TD><TD align="right">22</TD><TD>45-22=23</TD><TD>(TOTAL AVL QUNTY IS 45)</TD></TR><TR><TD align="right" height="20">2</TD><TD>A</TD><TD align="right">5</TD><TD class="xl65">10-5</TD><TD>(TOTAL AVL QUNTY IS 10, AS 10 ALREADY USED IN #1)</TD></TR><TR><TD align="right" height="20">2</TD><TD>B</TD><TD align="right">20</TD><TD>23-20=3</TD><TD>(TOTAL AVL QUNTY IS 22, AS 22 ALREADY USED IN #2)</TD></TR><TR><TD align="right" height="20">2</TD><TD>C</TD><TD align="right">10</TD><TD>55-10</TD><TD>(TOTAL AVL QUNTY IS 55)</TD></TR></TBODY></TABLE><P></P><P>Please help.. </P><P></P><P>Thanks</P><P>Sandeep</P></BODY></HTML> Mon, 15 Jan 2018 16:28:09 GMT Anonymous 2018-01-15T16:28:09Z How to get balance quantity ?? https://community.qlik.com/t5/QlikView/How-to-get-balance-quantity/m-p/983#M609439 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P>I have two tables.</P><P></P><P>TABLE1</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 196px;"><TBODY><TR><TD height="20" width="64">PRIORITY</TD><TD width="64">CODE</TD><TD width="68">QNTY</TD></TR><TR><TD align="right" height="20">1</TD><TD>A</TD><TD align="right">10</TD></TR><TR><TD align="right" height="20">1</TD><TD>B</TD><TD align="right">22</TD></TR><TR><TD align="right" height="20">2</TD><TD>A</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">2</TD><TD>B</TD><TD align="right">20</TD></TR><TR><TD align="right" height="20">2</TD><TD>C</TD><TD align="right">10</TD></TR></TBODY></TABLE><P></P><P>TABLE 2</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 105px;"><TBODY><TR><TD class="xl65" height="20" width="64">CODE </TD><TD class="xl65" style="border-left: none;" width="41">TOTAL QNTY</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">25</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">45</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">55</TD></TR></TBODY></TABLE><P></P><P>from above two tables I required below result.</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 586px;"><TBODY><TR><TD height="20" width="64">PRIORITY</TD><TD width="64">CODE</TD><TD width="64">QNTY</TD><TD width="68">AVL QNTY</TD><TD></TD></TR><TR><TD align="right" height="20">1</TD><TD>A</TD><TD align="right">10</TD><TD>25-10 =10</TD><TD>(TOTAL AVL QUNTY IS 25)</TD></TR><TR><TD align="right" height="20">1</TD><TD>B</TD><TD align="right">22</TD><TD>45-22=23</TD><TD>(TOTAL AVL QUNTY IS 45)</TD></TR><TR><TD align="right" height="20">2</TD><TD>A</TD><TD align="right">5</TD><TD class="xl65">10-5</TD><TD>(TOTAL AVL QUNTY IS 10, AS 10 ALREADY USED IN #1)</TD></TR><TR><TD align="right" height="20">2</TD><TD>B</TD><TD align="right">20</TD><TD>23-20=3</TD><TD>(TOTAL AVL QUNTY IS 22, AS 22 ALREADY USED IN #2)</TD></TR><TR><TD align="right" height="20">2</TD><TD>C</TD><TD align="right">10</TD><TD>55-10</TD><TD>(TOTAL AVL QUNTY IS 55)</TD></TR></TBODY></TABLE><P></P><P>Please help.. </P><P></P><P>Thanks</P><P>Sandeep</P></BODY></HTML> Mon, 15 Jan 2018 16:28:09 GMT https://community.qlik.com/t5/QlikView/How-to-get-balance-quantity/m-p/983#M609439 Anonymous 2018-01-15T16:28:09Z