<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Calculo Base Acumulado in Brasil</title>
    <link>https://community.qlik.com/t5/Brasil/Calculo-Base-Acumulado/m-p/675765#M19461</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Bom dia João Carlos&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Simplifiquei um pouco meu qvd para facilitar até mesmo minha pegunta.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;O que preciso é incluir uma coluna neste qvd com o acumulado das vendas, porem quando eu selecionar um mês ele tem que trazer o acumulado até o mês selecionado. isso vale para seleção de ano ou dia.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Obrigado pela força!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Att,&lt;/P&gt;&lt;P&gt;Mercadante&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 08 Oct 2014 14:44:41 GMT</pubDate>
    <dc:creator>mercadante</dc:creator>
    <dc:date>2014-10-08T14:44:41Z</dc:date>
    <item>
      <title>Calculo Base Acumulado</title>
      <link>https://community.qlik.com/t5/Brasil/Calculo-Base-Acumulado/m-p/675763#M19459</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Srs.(as) Boa tarde!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333339691162px;"&gt;Por gentileza? &lt;/SPAN&gt;Alguém pode me ajudar com essa dificuldade&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt; Tenho uma visão de base de cliente, porem quando seleciono um mês ele respeita minha seleção e trás somente a base do mês selecionado, ou do ano, etc.&lt;/P&gt;&lt;P&gt;&amp;nbsp; Preciso que ele traga o acumulado até a data selecionada.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Se alguém tiver um exemplo, eu agradeço&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;A expressão abaixo me atende se eu não fizer nenhuma seleção&lt;/P&gt;&lt;P&gt;=&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; (&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; sum({$&amp;lt;Identificador = {'CANC'},DATA_HABILITACAO_PONTO =-{''},&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; [Chave Expurgo] = {"=sum({$&amp;lt;Identificador = {'A'}, DATA_HABILITACAO_PONTO = -{''}&amp;gt;}Contador)"}&amp;gt;}[Contador])&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; +&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; sum({$&amp;lt;Identificador = {'CANC'},DATA_HABILITACAO_PONTO =- {''}&amp;gt;}Contador)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; )&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; /&lt;/P&gt;&lt;P&gt; RangeSum&lt;/P&gt;&lt;P&gt;&amp;nbsp; (&lt;/P&gt;&lt;P&gt;&amp;nbsp; (&lt;/P&gt;&lt;P&gt;&amp;nbsp; sum({1&amp;lt;Identificador = {'A'}&amp;gt;}Contador)&lt;/P&gt;&lt;P&gt;&amp;nbsp; -&lt;/P&gt;&lt;P&gt;&amp;nbsp; sum({1&amp;lt;Identificador = {'CANC'},DATA_HABILITACAO_PONTO =-{''},&lt;/P&gt;&lt;P&gt;&amp;nbsp; [Chave Expurgo] = {"=sum({1&amp;lt;Identificador = {'A'}, DATA_HABILITACAO_PONTO = -{''}&amp;gt;}Contador)"}&amp;gt;}[Contador])&lt;/P&gt;&lt;P&gt;&amp;nbsp; )&lt;/P&gt;&lt;P&gt;&amp;nbsp; -&lt;/P&gt;&lt;P&gt;&amp;nbsp; sum({1&amp;lt;Identificador = {'CANC'},DATA_HABILITACAO_PONTO =- {''}&amp;gt;}Contador)&lt;/P&gt;&lt;P&gt;&amp;nbsp; ,&lt;/P&gt;&lt;P&gt;&amp;nbsp; Above&lt;/P&gt;&lt;P&gt;&amp;nbsp; (&lt;/P&gt;&lt;P&gt;&amp;nbsp; (&lt;/P&gt;&lt;P&gt;&amp;nbsp; sum({1&amp;lt;Identificador = {'A'}&amp;gt;}Contador)&lt;/P&gt;&lt;P&gt;&amp;nbsp; -&lt;/P&gt;&lt;P&gt;&amp;nbsp; sum({1&amp;lt;Identificador = {'CANC'},DATA_HABILITACAO_PONTO =-{''},&lt;/P&gt;&lt;P&gt;&amp;nbsp; [Chave Expurgo] = {"=sum({1&amp;lt;Identificador = {'A'}, DATA_HABILITACAO_PONTO = -{''}&amp;gt;}Contador)"}&amp;gt;}[Contador])&lt;/P&gt;&lt;P&gt;&amp;nbsp; )&lt;/P&gt;&lt;P&gt;&amp;nbsp; -&lt;/P&gt;&lt;P&gt;&amp;nbsp; sum({1&amp;lt;Identificador = {'CANC'},DATA_HABILITACAO_PONTO =- {''}&amp;gt;}Contador)&lt;/P&gt;&lt;P&gt;&amp;nbsp; ,&lt;/P&gt;&lt;P&gt;&amp;nbsp; 1&lt;/P&gt;&lt;P&gt;&amp;nbsp; ,&lt;/P&gt;&lt;P&gt;&amp;nbsp; Rowno()&lt;/P&gt;&lt;P&gt;&amp;nbsp; )&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; )&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Obrigado!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 07 Oct 2014 18:28:37 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Brasil/Calculo-Base-Acumulado/m-p/675763#M19459</guid>
      <dc:creator>mercadante</dc:creator>
      <dc:date>2014-10-07T18:28:37Z</dc:date>
    </item>
    <item>
      <title>Re: Calculo Base Acumulado</title>
      <link>https://community.qlik.com/t5/Brasil/Calculo-Base-Acumulado/m-p/675764#M19460</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Bom dia Antônio,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Poderia postar o qvw para analisar seu cálculo e entender melhor sua necessidade.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Att,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; João Carlos&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 08 Oct 2014 12:00:06 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Brasil/Calculo-Base-Acumulado/m-p/675764#M19460</guid>
      <dc:creator>joao_sp_campina</dc:creator>
      <dc:date>2014-10-08T12:00:06Z</dc:date>
    </item>
    <item>
      <title>Re: Calculo Base Acumulado</title>
      <link>https://community.qlik.com/t5/Brasil/Calculo-Base-Acumulado/m-p/675765#M19461</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Bom dia João Carlos&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Simplifiquei um pouco meu qvd para facilitar até mesmo minha pegunta.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;O que preciso é incluir uma coluna neste qvd com o acumulado das vendas, porem quando eu selecionar um mês ele tem que trazer o acumulado até o mês selecionado. isso vale para seleção de ano ou dia.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Obrigado pela força!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Att,&lt;/P&gt;&lt;P&gt;Mercadante&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 08 Oct 2014 14:44:41 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Brasil/Calculo-Base-Acumulado/m-p/675765#M19461</guid>
      <dc:creator>mercadante</dc:creator>
      <dc:date>2014-10-08T14:44:41Z</dc:date>
    </item>
  </channel>
</rss>

