topic Set expressions in QlikView

topic Set expressions in QlikView https://community.qlik.com/t5/QlikView/Set-expressions/m-p/1165871#M629731 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="20" width="64">Table A</TD><TD width="64"></TD><TD width="64"></TD><TD width="64"></TD><TD width="64"></TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD class="xl65" height="20">S.no</TD><TD class="xl65" style="border-left: none;">code</TD><TD class="xl65" style="border-left: none;">Doc.code</TD><TD class="xl65" style="border-left: none;">Total</TD><TD></TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1001</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">20</TD><TD></TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1002</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">40</TD><TD></TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1003</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">30</TD><TD></TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">4</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1004</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50</TD><TD></TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">5</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1005</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">80</TD><TD></TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">Table B</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD class="xl65" height="20">s.no</TD><TD class="xl65" style="border-left: none;">code</TD><TD class="xl65" style="border-left: none;">Ref code</TD><TD class="xl65" style="border-left: none;">Ref Doc code</TD><TD class="xl65" style="border-left: none;">Total</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">SRLE</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1002</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">20</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">SRLE</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1004</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">40</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD class="xl65" style="border-top: none; border-left: none;">SRLE</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1005</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">80</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P></P><P>hI above are my two tables .</P><P></P><P>table A is invoice  and table B is sales return.</P><P>i need to find the sum of sales by subtracting the second table . as if sales return has been done it wont be consider as profit.</P><P></P><P>how can i achieve this in expression. please help</P><P>Thanks</P><P>Vignesh</P></BODY></HTML> Thu, 08 Sep 2016 10:30:57 GMT 2016-09-08T10:30:57Z Set expressions https://community.qlik.com/t5/QlikView/Set-expressions/m-p/1165871#M629731 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="20" width="64">Table A</TD><TD width="64"></TD><TD width="64"></TD><TD width="64"></TD><TD width="64"></TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD class="xl65" height="20">S.no</TD><TD class="xl65" style="border-left: none;">code</TD><TD class="xl65" style="border-left: none;">Doc.code</TD><TD class="xl65" style="border-left: none;">Total</TD><TD></TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1001</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">20</TD><TD></TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1002</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">40</TD><TD></TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1003</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">30</TD><TD></TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">4</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1004</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50</TD><TD></TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">5</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1005</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">80</TD><TD></TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">Table B</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD class="xl65" height="20">s.no</TD><TD class="xl65" style="border-left: none;">code</TD><TD class="xl65" style="border-left: none;">Ref code</TD><TD class="xl65" style="border-left: none;">Ref Doc code</TD><TD class="xl65" style="border-left: none;">Total</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">SRLE</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1002</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">20</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">SRLE</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1004</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">40</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD class="xl65" style="border-top: none; border-left: none;">SRLE</TD><TD class="xl65" style="border-top: none; border-left: none;">ILE</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1005</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">80</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P></P><P>hI above are my two tables .</P><P></P><P>table A is invoice  and table B is sales return.</P><P>i need to find the sum of sales by subtracting the second table . as if sales return has been done it wont be consider as profit.</P><P></P><P>how can i achieve this in expression. please help</P><P>Thanks</P><P>Vignesh</P></BODY></HTML> Thu, 08 Sep 2016 10:30:57 GMT https://community.qlik.com/t5/QlikView/Set-expressions/m-p/1165871#M629731 2016-09-08T10:30:57Z