topic Estoque - Qlikview in Brasil https://community.qlik.com/t5/Brasil/Estoque-Qlikview/m-p/1227832#M43486 <HTML><HEAD></HEAD><BODY><P>Boa tarde.</P><P></P><P>Segue duvida </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Inicial</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Consumo</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Período</STRONG></TH></TR><TR><TD style="padding: 2px;">500</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">2016 01</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">2016 02</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">2016 03</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">2016 04</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">2016 05</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">2016 06</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">2016 07</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">2016 08</TD></TR></TBODY></TABLE><P></P><P>Preciso pegar o valor inicial + consumo e mostrar no mês.</P><P></P><P>Ex. Mês 2016 02 deve mostrar 550 (500+50)</P><P>Mês 2016 03 = 565 <SPAN style="font-size: 13.3333px;">(500+50+15)</SPAN></P><P><SPAN style="font-size: 13.3333px;">Mês 2016 04 = 575 </SPAN><SPAN style="font-size: 13.3333px;">(500+50+15+10)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Mês 2016 05 = 575 </SPAN><SPAN style="font-size: 13.3333px;">(500+50+15+10+0)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Mês 2016 06 = 575 </SPAN><SPAN style="font-size: 13.3333px;">(500+50+15+10+0+0)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Mês 2016 07 = 575 </SPAN><SPAN style="font-size: 13.3333px;">(500+50+15+10+0+0+0)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Mês 2016 08 = 595 </SPAN><SPAN style="font-size: 13.3333px;">(500+50+15+10+0+0+0+20)</SPAN></SPAN></P><P></P><P>Como faço esse acumulado mensal.</P><P></P><P>Tentei usar o Previous, porém como vou saber se tenho que pegar do ultimo.. penúltimo ou do primeiro?</P></BODY></HTML> Tue, 24 Jan 2017 16:44:38 GMT EduardoAlexandredeFrancisco 2017-01-24T16:44:38Z Estoque - Qlikview https://community.qlik.com/t5/Brasil/Estoque-Qlikview/m-p/1227832#M43486 <HTML><HEAD></HEAD><BODY><P>Boa tarde.</P><P></P><P>Segue duvida </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Inicial</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Consumo</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Período</STRONG></TH></TR><TR><TD style="padding: 2px;">500</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">2016 01</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">2016 02</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">2016 03</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">2016 04</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">2016 05</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">2016 06</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">2016 07</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">2016 08</TD></TR></TBODY></TABLE><P></P><P>Preciso pegar o valor inicial + consumo e mostrar no mês.</P><P></P><P>Ex. Mês 2016 02 deve mostrar 550 (500+50)</P><P>Mês 2016 03 = 565 <SPAN style="font-size: 13.3333px;">(500+50+15)</SPAN></P><P><SPAN style="font-size: 13.3333px;">Mês 2016 04 = 575 </SPAN><SPAN style="font-size: 13.3333px;">(500+50+15+10)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Mês 2016 05 = 575 </SPAN><SPAN style="font-size: 13.3333px;">(500+50+15+10+0)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Mês 2016 06 = 575 </SPAN><SPAN style="font-size: 13.3333px;">(500+50+15+10+0+0)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Mês 2016 07 = 575 </SPAN><SPAN style="font-size: 13.3333px;">(500+50+15+10+0+0+0)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Mês 2016 08 = 595 </SPAN><SPAN style="font-size: 13.3333px;">(500+50+15+10+0+0+0+20)</SPAN></SPAN></P><P></P><P>Como faço esse acumulado mensal.</P><P></P><P>Tentei usar o Previous, porém como vou saber se tenho que pegar do ultimo.. penúltimo ou do primeiro?</P></BODY></HTML> Tue, 24 Jan 2017 16:44:38 GMT https://community.qlik.com/t5/Brasil/Estoque-Qlikview/m-p/1227832#M43486 EduardoAlexandredeFrancisco 2017-01-24T16:44:38Z Re: Estoque - Qlikview https://community.qlik.com/t5/Brasil/Estoque-Qlikview/m-p/1227833#M43487 <HTML><HEAD></HEAD><BODY><P>Amigo;</P><P></P><P>Veja se atende:<A href="https://community.qlik.com/thread/117801">Acumular valores via Script</A></P></BODY></HTML> Tue, 24 Jan 2017 17:03:18 GMT https://community.qlik.com/t5/Brasil/Estoque-Qlikview/m-p/1227833#M43487 mario_sergio_ti 2017-01-24T17:03:18Z Re: Estoque - Qlikview https://community.qlik.com/t5/Brasil/Estoque-Qlikview/m-p/1227834#M43488 <HTML><HEAD></HEAD><BODY><P>Eduardo,</P><P></P><P>segue uma ideia.....</P><P></P><P><IMG alt="2017-01-24 20_24_40-QlikView x64 - [C__Furtado_Qlik_QlikView_Demos_Community_Saldo inicial + Acumula.png" class="jive-image image-1" src="/legacyfs/online/150758_2017-01-24 20_24_40-QlikView x64 - [C__Furtado_Qlik_QlikView_Demos_Community_Saldo inicial + Acumula.png" style="height: 218px; width: 620px;" /></P></BODY></HTML> Tue, 24 Jan 2017 22:25:33 GMT https://community.qlik.com/t5/Brasil/Estoque-Qlikview/m-p/1227834#M43488 afurtado 2017-01-24T22:25:33Z