topic Peek Help with script in QlikView https://community.qlik.com/t5/QlikView/Peek-Help-with-script/m-p/1404976#M610329 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello Everyone,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I'm tring to create a logic with the below sample data:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> <STRONG style="color: #3d3d3d; font-family: inherit; font-size: 13px; font-style: inherit;">Req O/P: </STRONG><SPAN style="color: #3d3d3d; font-family: inherit; font-size: 13px; font-style: inherit; font-weight: inherit;">'Can fill' column</SPAN></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 526px;"><TBODY><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl65" height="43" style="font-style: inherit;" width="80">ITEM</TD><TD class="xl65" style="font-style: inherit;" width="126">Incoming Date</TD><TD class="xl65" style="font-style: inherit;" width="80">Incoming_Qty</TD><TD class="xl65" style="font-style: inherit;" width="80">&nbsp; Required</TD><TD class="xl65" style="font-style: inherit;" width="80"><STRONG style="text-decoration: underline;">Can fill</STRONG></TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD align="right" class="xl65" height="25" style="font-style: inherit;" width="80">1</TD><TD class="xl67" style="font-style: inherit;" width="126">10/19/2017</TD><TD class="xl66" style="font-style: inherit;" width="80">81</TD><TD class="xl65" style="font-style: inherit;" width="80">&nbsp;&nbsp;&nbsp; 126</TD><TD class="xl66" style="font-style: inherit;" width="80"><STRONG>81</STRONG></TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD align="right" class="xl65" height="25" style="font-style: inherit;" width="80">1</TD><TD class="xl67" style="font-style: inherit;" width="126">11/1/2017</TD><TD class="xl66" style="font-style: inherit;" width="80">122&nbsp;&nbsp; </TD><TD class="xl66" style="font-style: inherit;" width="80"></TD><TD><STRONG>45</STRONG></TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD align="right" class="xl65" height="25" style="font-style: inherit;" width="80">1</TD><TD class="xl67" style="font-style: inherit;" width="126">11/1/2017</TD><TD class="xl66" style="font-style: inherit;" width="80">214</TD><TD></TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD align="right" class="xl65" height="25" style="font-style: inherit;" width="80">1</TD><TD class="xl67" style="font-style: inherit;" width="126">11/9/2017</TD><TD class="xl66" style="font-style: inherit;" width="80">233</TD><TD></TD></TR></TBODY></TABLE><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"></TBODY></TABLE><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have 126 units required.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> i'm getting 81 on one date. So, i can fill only 81 units.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Now, the rem. quantity is 45. This can be filled with the incoming qty on 11/1/2017.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> Please see attached application.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Any help is highly appreciated.</P></BODY></HTML> Fri, 20 Oct 2017 18:36:19 GMT markgraham123 2017-10-20T18:36:19Z Peek Help with script https://community.qlik.com/t5/QlikView/Peek-Help-with-script/m-p/1404976#M610329 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello Everyone,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I'm tring to create a logic with the below sample data:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> <STRONG style="color: #3d3d3d; font-family: inherit; font-size: 13px; font-style: inherit;">Req O/P: </STRONG><SPAN style="color: #3d3d3d; font-family: inherit; font-size: 13px; font-style: inherit; font-weight: inherit;">'Can fill' column</SPAN></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 526px;"><TBODY><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl65" height="43" style="font-style: inherit;" width="80">ITEM</TD><TD class="xl65" style="font-style: inherit;" width="126">Incoming Date</TD><TD class="xl65" style="font-style: inherit;" width="80">Incoming_Qty</TD><TD class="xl65" style="font-style: inherit;" width="80">&nbsp; Required</TD><TD class="xl65" style="font-style: inherit;" width="80"><STRONG style="text-decoration: underline;">Can fill</STRONG></TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD align="right" class="xl65" height="25" style="font-style: inherit;" width="80">1</TD><TD class="xl67" style="font-style: inherit;" width="126">10/19/2017</TD><TD class="xl66" style="font-style: inherit;" width="80">81</TD><TD class="xl65" style="font-style: inherit;" width="80">&nbsp;&nbsp;&nbsp; 126</TD><TD class="xl66" style="font-style: inherit;" width="80"><STRONG>81</STRONG></TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD align="right" class="xl65" height="25" style="font-style: inherit;" width="80">1</TD><TD class="xl67" style="font-style: inherit;" width="126">11/1/2017</TD><TD class="xl66" style="font-style: inherit;" width="80">122&nbsp;&nbsp; </TD><TD class="xl66" style="font-style: inherit;" width="80"></TD><TD><STRONG>45</STRONG></TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD align="right" class="xl65" height="25" style="font-style: inherit;" width="80">1</TD><TD class="xl67" style="font-style: inherit;" width="126">11/1/2017</TD><TD class="xl66" style="font-style: inherit;" width="80">214</TD><TD></TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD align="right" class="xl65" height="25" style="font-style: inherit;" width="80">1</TD><TD class="xl67" style="font-style: inherit;" width="126">11/9/2017</TD><TD class="xl66" style="font-style: inherit;" width="80">233</TD><TD></TD></TR></TBODY></TABLE><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"></TBODY></TABLE><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have 126 units required.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> i'm getting 81 on one date. So, i can fill only 81 units.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Now, the rem. quantity is 45. This can be filled with the incoming qty on 11/1/2017.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> Please see attached application.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Any help is highly appreciated.</P></BODY></HTML> Fri, 20 Oct 2017 18:36:19 GMT https://community.qlik.com/t5/QlikView/Peek-Help-with-script/m-p/1404976#M610329 markgraham123 2017-10-20T18:36:19Z