topic Valor Acumulado in Brasil https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253235#M8461 <HTML><HEAD></HEAD><BODY><P>Olá, era isso mesmo!</P><P></P><P>Só mais uma coisa, é possivel eu criar uma condição para que quando eu selecione</P><P>2 meses ou mais, ele me mostre detalhamento de&nbsp; custo de cada mês e mostre o Total?</P><P></P><P>Desc.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fev&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70</P><P></P><P></P><P>Muito Obrigada!&nbsp; </P></BODY></HTML> Mon, 06 Feb 2012 21:01:49 GMT 2012-02-06T21:01:49Z Valor Acumulado https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253231#M8457 <HTML><HEAD></HEAD><BODY><P>Boa tarde, pessoal!</P><P></P><P>Estou precisando fazer um acumulado num tabela dinâmica, já pesquisei em muitos foruns mas não achei nada.</P><P></P><P>Eu preciso mostrar na minha tabela dois valores distintos, e um deles é um acumulado, exemplo:</P><P></P><P></P><P>Se eu selecione o mês de jun de 2011, ele tem que me mostrar um coluna com a soma do mês referente (jun 2011)</P><P>e em outra coluna o soma do valor acumulado do mês de jan até jun de 2011.</P><P>E assim para todos os meses.</P><P></P><P>Qualquer sugestão será valiosa.</P><P></P><P></P><P>Att,</P><P></P><P>Ingrid</P></BODY></HTML> Fri, 03 Feb 2012 16:25:37 GMT https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253231#M8457 2012-02-03T16:25:37Z Re: Valor Acumulado https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253232#M8458 <HTML><HEAD></HEAD><BODY><P>Ingrid, dependendo do cenário você consegue criar a coluna acumulado através de formulas.</P><P>Em anexo coloquei um exemplo que funciona para um caso simples de tabela dinâmica.</P><P>Qualquer dúvida fico a disposição.</P><P></P><P>att.</P><P>Hudson</P></BODY></HTML> Fri, 03 Feb 2012 17:29:12 GMT https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253232#M8458 2012-02-03T17:29:12Z Valor Acumulado https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253233#M8459 <HTML><HEAD></HEAD><BODY><P>Não é bem isso, vou tentar desenhar pra ver se me entender melhor:</P><P></P><P></P><P>Descrição&nbsp;&nbsp;&nbsp;&nbsp; Atual&nbsp;&nbsp;&nbsp;&nbsp; Anterior&nbsp;&nbsp;&nbsp;&nbsp; Acumulado</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70</P><P></P><P></P><P>Acho que dá pra enteder agora...</P><P></P><P>Muito Obrigada!</P></BODY></HTML> Mon, 06 Feb 2012 16:53:17 GMT https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253233#M8459 2012-02-06T16:53:17Z Re: Valor Acumulado https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253234#M8460 <HTML><HEAD></HEAD><BODY><P>Olá, acredito que seja isso... </P><P></P><P>expressão atual&nbsp; : </P><P><EM>sum(Valor)</EM></P><P></P><P>expressão Anterior:</P><P><EM>sum( {1&lt;mês = {'&lt;$(=GetFieldSelections(mês))'}&gt;} Valor)</EM></P><P></P><P></P><P>acumulado:</P><P><EM>atual - anterior</EM></P><P></P><P></P><P><EM>ps: o campo mês é numérico.</EM></P><P></P><P></P><P><EM>segue um exemplo<BR /></EM></P></BODY></HTML> Mon, 06 Feb 2012 17:42:06 GMT https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253234#M8460 Anonymous 2012-02-06T17:42:06Z Valor Acumulado https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253235#M8461 <HTML><HEAD></HEAD><BODY><P>Olá, era isso mesmo!</P><P></P><P>Só mais uma coisa, é possivel eu criar uma condição para que quando eu selecione</P><P>2 meses ou mais, ele me mostre detalhamento de&nbsp; custo de cada mês e mostre o Total?</P><P></P><P>Desc.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fev&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70</P><P></P><P></P><P>Muito Obrigada!&nbsp; </P></BODY></HTML> Mon, 06 Feb 2012 21:01:49 GMT https://community.qlik.com/t5/Brasil/Valor-Acumulado/m-p/253235#M8461 2012-02-06T21:01:49Z