topic Re: Expressão Mês Ano Anterior in Brasil https://community.qlik.com/t5/Brasil/Express%C3%A3o-M%C3%AAs-Ano-Anterior/m-p/136364#M7553 <HTML><HEAD></HEAD><BODY><P>Yuri, a ideia é montar um gráfico com uma linha do tempo, sendo que o % é a comparação com o mesmo mês do ano anterior. No qvw que passei é possivel fazer?<IMG alt="Capturar.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207749_Capturar.JPG" style="height: 128px; width: 620px;" /></P></BODY></HTML> Thu, 12 Jul 2018 16:57:10 GMT tiagofarias 2018-07-12T16:57:10Z Expressão Mês Ano Anterior https://community.qlik.com/t5/Brasil/Express%C3%A3o-M%C3%AAs-Ano-Anterior/m-p/136362#M7551 <HTML><HEAD></HEAD><BODY><P>Bom dia</P><P></P><P>Preciso montar uma expressão onde por exemplo: a venda do mês seja comparada com o mês mesmo do ano anterior</P><P></P><P>Preciso que a expressão apareça os valores igual a tabela abaixo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 387px;"><TBODY><TR><TD class="xl64" height="45" width="71">Ano</TD><TD class="xl64" style="border-left: none;" width="42">Ano1</TD><TD class="xl64" style="border-left: none;" width="49">Mes</TD><TD class="xl64" style="border-left: none;" width="96">Venda</TD><TD class="xl65" style="border-left: none;" width="129">% Mesmo Mês Ano Anterior</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201601</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">1</TD><TD class="xl66" style="border-top: none; border-left: none;">3502</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201602</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">2</TD><TD class="xl66" style="border-top: none; border-left: none;">3156</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201603</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">3</TD><TD class="xl66" style="border-top: none; border-left: none;">2881</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201604</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">4</TD><TD class="xl66" style="border-top: none; border-left: none;">3814</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201605</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">5</TD><TD class="xl66" style="border-top: none; border-left: none;">4793</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201606</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">6</TD><TD class="xl66" style="border-top: none; border-left: none;">2050</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201607</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">7</TD><TD class="xl66" style="border-top: none; border-left: none;">4816</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201608</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">8</TD><TD class="xl66" style="border-top: none; border-left: none;">4162</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201609</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">9</TD><TD class="xl66" style="border-top: none; border-left: none;">2257</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201610</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">10</TD><TD class="xl66" style="border-top: none; border-left: none;">2214</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201611</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">11</TD><TD class="xl66" style="border-top: none; border-left: none;">1981</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201612</TD><TD class="xl66" style="border-top: none; border-left: none;">2016</TD><TD class="xl66" style="border-top: none; border-left: none;">12</TD><TD class="xl66" style="border-top: none; border-left: none;">3953</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201701</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">1</TD><TD class="xl66" style="border-top: none; border-left: none;">1823</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-48%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201702</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">2</TD><TD class="xl66" style="border-top: none; border-left: none;">3535</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">12%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201703</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">3</TD><TD class="xl66" style="border-top: none; border-left: none;">2186</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-24%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201704</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">4</TD><TD class="xl66" style="border-top: none; border-left: none;">2676</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-30%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201705</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">5</TD><TD class="xl66" style="border-top: none; border-left: none;">4940</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201706</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">6</TD><TD class="xl66" style="border-top: none; border-left: none;">1123</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-45%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201707</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">7</TD><TD class="xl66" style="border-top: none; border-left: none;">3812</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-21%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201708</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">8</TD><TD class="xl66" style="border-top: none; border-left: none;">3535</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-15%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201709</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">9</TD><TD class="xl66" style="border-top: none; border-left: none;">4787</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">112%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201710</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">10</TD><TD class="xl66" style="border-top: none; border-left: none;">4670</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">111%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201711</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">11</TD><TD class="xl66" style="border-top: none; border-left: none;">1566</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-21%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201712</TD><TD class="xl66" style="border-top: none; border-left: none;">2017</TD><TD class="xl66" style="border-top: none; border-left: none;">12</TD><TD class="xl66" style="border-top: none; border-left: none;">1962</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-50%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201801</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">1</TD><TD class="xl66" style="border-top: none; border-left: none;">2220</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">22%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201802</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">2</TD><TD class="xl66" style="border-top: none; border-left: none;">2820</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-20%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201803</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">3</TD><TD class="xl66" style="border-top: none; border-left: none;">4144</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">90%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201804</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">4</TD><TD class="xl66" style="border-top: none; border-left: none;">2088</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-22%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201805</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">5</TD><TD class="xl66" style="border-top: none; border-left: none;">2842</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-42%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201806</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">6</TD><TD class="xl66" style="border-top: none; border-left: none;">4587</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">308%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201807</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">7</TD><TD class="xl66" style="border-top: none; border-left: none;">3862</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201808</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">8</TD><TD class="xl66" style="border-top: none; border-left: none;">3739</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201809</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">9</TD><TD class="xl66" style="border-top: none; border-left: none;">4699</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-2%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201810</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">10</TD><TD class="xl66" style="border-top: none; border-left: none;">1826</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-61%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201811</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">11</TD><TD class="xl66" style="border-top: none; border-left: none;">1516</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-3%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">201812</TD><TD class="xl66" style="border-top: none; border-left: none;">2018</TD><TD class="xl66" style="border-top: none; border-left: none;">12</TD><TD class="xl66" style="border-top: none; border-left: none;">4597</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">134%</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 12 Jul 2018 14:46:34 GMT https://community.qlik.com/t5/Brasil/Express%C3%A3o-M%C3%AAs-Ano-Anterior/m-p/136362#M7551 tiagofarias 2018-07-12T14:46:34Z Re: Expressão Mês Ano Anterior https://community.qlik.com/t5/Brasil/Express%C3%A3o-M%C3%AAs-Ano-Anterior/m-p/136363#M7552 <HTML><HEAD></HEAD><BODY><P>Se você quiser manter esse cálculo em um gráfico que possua o mês e ano na dimensão, você terá que trabalhar com o conceito de AsOf</P><P></P><P>Aqui tem um exemplo que montei: <A href="https://community.qlik.com/message/1457979">Re: Dados do mês anterior e total</A></P></BODY></HTML> Thu, 12 Jul 2018 14:49:50 GMT https://community.qlik.com/t5/Brasil/Express%C3%A3o-M%C3%AAs-Ano-Anterior/m-p/136363#M7552 nicolett_yuri 2018-07-12T14:49:50Z Re: Expressão Mês Ano Anterior https://community.qlik.com/t5/Brasil/Express%C3%A3o-M%C3%AAs-Ano-Anterior/m-p/136364#M7553 <HTML><HEAD></HEAD><BODY><P>Yuri, a ideia é montar um gráfico com uma linha do tempo, sendo que o % é a comparação com o mesmo mês do ano anterior. No qvw que passei é possivel fazer?<IMG alt="Capturar.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207749_Capturar.JPG" style="height: 128px; width: 620px;" /></P></BODY></HTML> Thu, 12 Jul 2018 16:57:10 GMT https://community.qlik.com/t5/Brasil/Express%C3%A3o-M%C3%AAs-Ano-Anterior/m-p/136364#M7553 tiagofarias 2018-07-12T16:57:10Z Re: Expressão Mês Ano Anterior https://community.qlik.com/t5/Brasil/Express%C3%A3o-M%C3%AAs-Ano-Anterior/m-p/136365#M7554 <HTML><HEAD></HEAD><BODY><P>Sim, só utilizar o conceito que te passei: criar uma tabela com De/Para de datas.</P><P>Se tiver dificuldades com a solução, nos informe</P></BODY></HTML> Fri, 13 Jul 2018 12:42:05 GMT https://community.qlik.com/t5/Brasil/Express%C3%A3o-M%C3%AAs-Ano-Anterior/m-p/136365#M7554 nicolett_yuri 2018-07-13T12:42:05Z