topic Re: Next arrivals in QlikView https://community.qlik.com/t5/QlikView/Next-arrivals/m-p/482817#M180456 <HTML><HEAD></HEAD><BODY><P>=min({&lt;Stock={"$(sSitio)"}&gt;} Ingreso)</P><P>firstsortedvalue({&lt;Stock={"$(sSitio)"}&gt;}Cantidad,Ingreso)</P></BODY></HTML> Thu, 26 Sep 2013 21:50:07 GMT Clever_Anjos 2013-09-26T21:50:07Z Next arrivals https://community.qlik.com/t5/QlikView/Next-arrivals/m-p/482815#M180454 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P><SPAN lang="en"><SPAN class="hps">I have</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">determine the next</SPAN> <SPAN class="hps">arrivals for</SPAN> <SPAN class="hps">each product</SPAN>, <SPAN class="hps">with date and</SPAN> <SPAN class="hps">quantity</SPAN>.<BR /><SPAN class="hps">This is for the</SPAN> <SPAN class="hps">Stock</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps">000002</SPAN>, that value <SPAN class="hps">is in the</SPAN> <SPAN class="atn hps">variable '</SPAN>sSitio'.<BR /><SPAN class="hps">I can</SPAN> <SPAN class="hps">not</SPAN> <SPAN class="hps">do it</SPAN> <SPAN class="hps">by</SPAN> <SPAN class="hps">script</SPAN>, I need <SPAN class="hps">to solve it</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">pivot table</SPAN>.<BR /><SPAN class="hps">For example</SPAN>: <SPAN class="hps">001.001.05.0007</SPAN> <SPAN class="hps">product</SPAN> <SPAN class="hps">should</SPAN> <SPAN class="hps">show</SPAN>: <SPAN class="hps">NextArrivals</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps">27/07/2013</SPAN>, <SPAN class="hps">Quantity =</SPAN> <SPAN class="hps">105</SPAN>.</SPAN></P><P><SPAN lang="en"></SPAN></P><DIV><DIV><DIV><DIV class="goog-inline-block trans-pb-button goog-toolbar-button" data-tooltip="Guardar en Vocabulario" data-tooltip-align="t,c"><SPAN class="jfk-button-img"><SPAN class="hps">File</SPAN> <SPAN class="hps">Attachment</SPAN>..</SPAN></DIV></DIV><DIV class="select-button goog-toolbar-button" data-tooltip="Seleccionar todo" data-tooltip-align="t,c"><SPAN class="jfk-button-img"></SPAN></DIV></DIV></DIV></BODY></HTML> Thu, 26 Sep 2013 13:07:33 GMT https://community.qlik.com/t5/QlikView/Next-arrivals/m-p/482815#M180454 spividori 2013-09-26T13:07:33Z Re: Next arrivals https://community.qlik.com/t5/QlikView/Next-arrivals/m-p/482816#M180455 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Any suggestions</SPAN>?. <SPAN class="hps">Help</SPAN> <SPAN class="hps">please!</SPAN>. <SPAN class="hps">Thank you.</SPAN></P><P><SPAN class="hps"></SPAN> </P><P><SPAN class="hps">Regards.</SPAN></P></BODY></HTML> Thu, 26 Sep 2013 21:16:10 GMT https://community.qlik.com/t5/QlikView/Next-arrivals/m-p/482816#M180455 spividori 2013-09-26T21:16:10Z Re: Next arrivals https://community.qlik.com/t5/QlikView/Next-arrivals/m-p/482817#M180456 <HTML><HEAD></HEAD><BODY><P>=min({&lt;Stock={"$(sSitio)"}&gt;} Ingreso)</P><P>firstsortedvalue({&lt;Stock={"$(sSitio)"}&gt;}Cantidad,Ingreso)</P></BODY></HTML> Thu, 26 Sep 2013 21:50:07 GMT https://community.qlik.com/t5/QlikView/Next-arrivals/m-p/482817#M180456 Clever_Anjos 2013-09-26T21:50:07Z Re: Next arrivals https://community.qlik.com/t5/QlikView/Next-arrivals/m-p/482818#M180457 <HTML><HEAD></HEAD><BODY><P>HI Clever.</P><P><SPAN class="hps">Thank you.</SPAN> <SPAN class="hps">Works</SPAN> <SPAN class="hps">perfect</SPAN>.</P><P></P><P>Regards.</P></BODY></HTML> Fri, 27 Sep 2013 13:40:27 GMT https://community.qlik.com/t5/QlikView/Next-arrivals/m-p/482818#M180457 spividori 2013-09-27T13:40:27Z