topic Not getting proper result, please hle in QlikView https://community.qlik.com/t5/QlikView/Not-getting-proper-result-please-hle/m-p/25#M609528 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have two tables .</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 319px;"><TBODY><TR><TD class="xl63" colspan="3" height="17" width="319">TABLE A</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CODE</TD><TD class="xl64" style="border-top: none; border-left: none;">NEED_DATE</TD><TD class="xl64" style="border-top: none; border-left: none;">A</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">12-Mar-18</TD><TD class="xl68" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">B</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">12-Mar-18</TD><TD class="xl66" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">B</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">12-Mar-18</TD><TD class="xl69" style="border-top: none; border-left: none;">3</TD></TR></TBODY></TABLE><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 304px;"><TBODY><TR><TD class="xl65" colspan="3" height="17" width="304">TABLE B</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">CODE</TD><TD class="xl66" style="border-top: none; border-left: none;">DELIVERY_DATE</TD><TD class="xl66" style="border-top: none; border-left: none;">B</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">02-Mar-18</TD><TD class="xl69" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">B</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">07-Jan-18</TD><TD class="xl70" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">D</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">18-Jul-18</TD><TD class="xl69" style="border-top: none; border-left: none;">8</TD></TR></TBODY></TABLE><P></P><P>in both tables CODE is the common attribute.</P><P>Based on condition where <SPAN style="font-size: 13.3333px;">DELIVERY_DATE &lt;= <SPAN style="font-size: 13.3333px;">NEED_DATE, I want below result .</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 282px;"><TBODY><TR><TD class="xl66" width="64">NEED_DATE</TD><TD class="xl66" width="95">SUM OF A</TD><TD class="xl66" width="95">SUM OF B</TD></TR><TR><TD align="right" class="xl65" height="17">12-Mar-18</TD><TD align="right">6</TD><TD align="right">15</TD></TR></TBODY></TABLE><P></P><P>Please help .</P><P></P><P>Thanks</P><P>Sandeep</P></BODY></HTML> Fri, 12 Jan 2018 13:50:14 GMT Anonymous 2018-01-12T13:50:14Z Not getting proper result, please hle https://community.qlik.com/t5/QlikView/Not-getting-proper-result-please-hle/m-p/25#M609528 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have two tables .</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 319px;"><TBODY><TR><TD class="xl63" colspan="3" height="17" width="319">TABLE A</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CODE</TD><TD class="xl64" style="border-top: none; border-left: none;">NEED_DATE</TD><TD class="xl64" style="border-top: none; border-left: none;">A</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">12-Mar-18</TD><TD class="xl68" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">B</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">12-Mar-18</TD><TD class="xl66" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">B</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">12-Mar-18</TD><TD class="xl69" style="border-top: none; border-left: none;">3</TD></TR></TBODY></TABLE><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 304px;"><TBODY><TR><TD class="xl65" colspan="3" height="17" width="304">TABLE B</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">CODE</TD><TD class="xl66" style="border-top: none; border-left: none;">DELIVERY_DATE</TD><TD class="xl66" style="border-top: none; border-left: none;">B</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">02-Mar-18</TD><TD class="xl69" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">B</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">07-Jan-18</TD><TD class="xl70" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">D</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">18-Jul-18</TD><TD class="xl69" style="border-top: none; border-left: none;">8</TD></TR></TBODY></TABLE><P></P><P>in both tables CODE is the common attribute.</P><P>Based on condition where <SPAN style="font-size: 13.3333px;">DELIVERY_DATE &lt;= <SPAN style="font-size: 13.3333px;">NEED_DATE, I want below result .</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 282px;"><TBODY><TR><TD class="xl66" width="64">NEED_DATE</TD><TD class="xl66" width="95">SUM OF A</TD><TD class="xl66" width="95">SUM OF B</TD></TR><TR><TD align="right" class="xl65" height="17">12-Mar-18</TD><TD align="right">6</TD><TD align="right">15</TD></TR></TBODY></TABLE><P></P><P>Please help .</P><P></P><P>Thanks</P><P>Sandeep</P></BODY></HTML> Fri, 12 Jan 2018 13:50:14 GMT https://community.qlik.com/t5/QlikView/Not-getting-proper-result-please-hle/m-p/25#M609528 Anonymous 2018-01-12T13:50:14Z Re: Not getting proper result, please hle https://community.qlik.com/t5/QlikView/Not-getting-proper-result-please-hle/m-p/26#M609529 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(If(DELIVERY_DATE &lt;= NEED_DATE, A))</STRONG></P><P><STRONG>Sum(If(DELIVERY_DATE &lt;= NEED_DATE, B))</STRONG></P></BODY></HTML> Fri, 12 Jan 2018 13:53:47 GMT https://community.qlik.com/t5/QlikView/Not-getting-proper-result-please-hle/m-p/26#M609529 sunny_talwar 2018-01-12T13:53:47Z