topic Re: Re: Re: Challenging............. in QlikView https://community.qlik.com/t5/QlikView/Challenging/m-p/489096#M1125352 <HTML><HEAD></HEAD><BODY><P>Thank U Ajay..</P><P></P><P>I did small correction.........</P></BODY></HTML> Thu, 09 Jan 2014 17:47:44 GMT 2014-01-09T17:47:44Z Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489087#M1125343 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #222222; font-family: arial, sans-serif;">Hi&nbsp; Community,</SPAN></P><P><SPAN style="color: #222222; font-family: arial, sans-serif;"><BR /></SPAN></P><DIV><STRONG>PFA</STRONG>,<P></P><P><STRONG>Material &amp; Plant as KEY</STRONG></P><P><STRONG><BR /></STRONG></P><P>Here in my table i have status(ok and invalid),</P><P>i want to compare with another table, only invalid field status.......</P><P>in my 3rd table i have a QTY field</P><P>i want to compare with this field (<STRONG>WRP QTY-ORDER QTY</STRONG>)</P><P></P><P>based on <STRONG>Material &amp; Plant as KEY</STRONG></P><P></P><P></P><P>Thanks in Advance.......</P></DIV></BODY></HTML> Thu, 09 Jan 2014 15:46:08 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489087#M1125343 2014-01-09T15:46:08Z Re: Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489088#M1125344 <HTML><HEAD></HEAD><BODY><P>Please any one can help me.........</P></BODY></HTML> Thu, 09 Jan 2014 16:27:13 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489088#M1125344 2014-01-09T16:27:13Z Re: Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489089#M1125345 <HTML><HEAD></HEAD><BODY><P>Anybody is there............</P></BODY></HTML> Thu, 09 Jan 2014 16:54:52 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489089#M1125345 2014-01-09T16:54:52Z Re: Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489090#M1125346 <HTML><HEAD></HEAD><BODY><P>I don't understand what you are trying to do.&nbsp; Can you explain some more?</P></BODY></HTML> Thu, 09 Jan 2014 16:57:13 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489090#M1125346 2014-01-09T16:57:13Z Re: Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489091#M1125347 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Order Date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Material No</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Plant</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>ATP Qty1</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Ordered Qty</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Cumulative Qty</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Status</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2-11-2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">28112</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A016</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">500</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">300</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">200</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ATP</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">22-11-2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">28112</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A016</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">200</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">200</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ATP</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">24-11-2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">28112</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A016</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">300</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-300</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Invalid</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">24-11-2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">28112</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A016</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-300</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">250</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-550</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Invalid</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">05-12-2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1234</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A017</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">80</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ATP</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">06-12-2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1234</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A017</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">30</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-10</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Invalid</SPAN></TD></TR></TBODY></TABLE><P></P><P><STRONG>WRP_Table:</STRONG></P><P><STRONG>LOAD *, [Material No] &amp; '|' &amp; [Plant] as Key </STRONG></P><P>INLINE [</P><P>MaterialNo1, Plant1, WRP Qty</P><P>28112,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A016,&nbsp;&nbsp;&nbsp;&nbsp; 350</P><P>1234,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A017,&nbsp;&nbsp;&nbsp;&nbsp; 80];</P><P></P><P>Here in my table <STRONG>invalid</STRONG> fields (Negative values), compare with the <STRONG>Order Qty and&nbsp; WRP_Qty </STRONG></P><P>(WRP QTY-ORDER QTY)</P><P></P><P>like this&nbsp;&nbsp; WRP_Qty=350</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OrderQty= 300</P><P><STRONG>350-300=50 status should be OK</STRONG></P><P></P><P>based on <STRONG>Material &amp; Plant Key</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P>Thanks in Advance<STRONG><BR /></STRONG></P></BODY></HTML> Thu, 09 Jan 2014 17:10:56 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489091#M1125347 2014-01-09T17:10:56Z Re: Re: Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489092#M1125348 <HTML><HEAD></HEAD><BODY><P>Hey Sunil,</P><P></P><P>I created a field called 'Flag'. Let me know if it meets your requirement.</P></BODY></HTML> Thu, 09 Jan 2014 17:13:33 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489092#M1125348 2014-01-09T17:13:33Z Re: Re: Re: Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489093#M1125349 <HTML><HEAD></HEAD><BODY><P>Made a small change based on your recent explanation.</P><P>check it now and let me know.</P><P></P><P>Thanks</P><P>AJ</P></BODY></HTML> Thu, 09 Jan 2014 17:16:51 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489093#M1125349 2014-01-09T17:16:51Z Re: Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489094#M1125350 <HTML><HEAD></HEAD><BODY><P>Hi Ajay,</P><P></P><P>Output would be </P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="border: 0px; font-size: 9pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR bgcolor="#f5f5f5" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; background-position: no-repeat no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">Order Date</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; background-position: no-repeat no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">Material No</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; background-position: no-repeat no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">Plant</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; background-position: no-repeat no-repeat;">RWt Qty</TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; background-position: no-repeat no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">ATP Qty1</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; background-position: no-repeat no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">Ordered Qty</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; background-position: no-repeat no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">Cumulative Qty</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; background-position: no-repeat no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">Status</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; background-position: no-repeat no-repeat;"><STRONG style="font-style: inherit; font-family: inherit;">Status_Flag</STRONG></TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">2-11-2013</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">28112</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">A016</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;">350</TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">500</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">300</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">200</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">ATP</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="color: #363636; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">ATP</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">22-11-2013</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">28112</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">A016</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;">350</TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">200</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">200</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">ATP</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="color: #363636; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">ATP</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">24-11-2013</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">28112</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">A016</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">350</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">300</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">-300</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">Invalid</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;">Ok</TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">24-11-2013</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">28112</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">A016</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">350</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">-300</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">-550</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">Invalid</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;">ok</TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">05-12-2013</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">1234</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">A017</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;">80</TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">100</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">80</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">20</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">ATP</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;">ATP</TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">06-12-2013</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">1234</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">A017</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;">80</TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">20</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">30</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">-10</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">Invalid</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;">ok</TD></TR></TBODY></TABLE><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RWT Qty-Order Qty= Status_Flag</P></BODY></HTML> Thu, 09 Jan 2014 17:33:00 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489094#M1125350 2014-01-09T17:33:00Z Re: Re: Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489095#M1125351 <HTML><HEAD></HEAD><BODY><P>Sorry used the wrong field. Check this one out.</P><P>Thanks</P><P>AJ</P></BODY></HTML> Thu, 09 Jan 2014 17:39:22 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489095#M1125351 2014-01-09T17:39:22Z Re: Re: Re: Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489096#M1125352 <HTML><HEAD></HEAD><BODY><P>Thank U Ajay..</P><P></P><P>I did small correction.........</P></BODY></HTML> Thu, 09 Jan 2014 17:47:44 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489096#M1125352 2014-01-09T17:47:44Z Re: Re: Re: Challenging............. https://community.qlik.com/t5/QlikView/Challenging/m-p/489097#M1125353 <HTML><HEAD></HEAD><BODY><P>Forgot to create the key while joining. Silly of me <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 09 Jan 2014 17:55:33 GMT https://community.qlik.com/t5/QlikView/Challenging/m-p/489097#M1125353 2014-01-09T17:55:33Z