topic Duvida com AVG in QlikView https://community.qlik.com/t5/QlikView/Duvida-com-AVG/m-p/1219908#M863210 <HTML><HEAD></HEAD><BODY><P>Boa tarde Pessoal,</P><P>Estou com dificuldades para projetar a media de vendas por mes. Minha tentativa no slide abaixo. Mas, gostaria de um resultado com o segundo slide. </P><P><SPAN style="font-size: 13.3333px;">Segue em anexo meu QVD.</SPAN></P><P><SPAN style="font-size: 13.3333px;">Obrigado desde já.<BR /></SPAN></P><P><IMG alt="Media de pedidos por mes.png" class="jive-image image-2" src="/legacyfs/online/147314_Media de pedidos por mes.png" style="height: 349px; width: 620px;" /></P><P></P><P></P><P><IMG __jive_id="147306" alt="DashboardEx2Temporario.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/147306_DashboardEx2Temporario.png" style="height: 357px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Duvida com AVG https://community.qlik.com/t5/QlikView/Duvida-com-AVG/m-p/1219908#M863210 <HTML><HEAD></HEAD><BODY><P>Boa tarde Pessoal,</P><P>Estou com dificuldades para projetar a media de vendas por mes. Minha tentativa no slide abaixo. Mas, gostaria de um resultado com o segundo slide. </P><P><SPAN style="font-size: 13.3333px;">Segue em anexo meu QVD.</SPAN></P><P><SPAN style="font-size: 13.3333px;">Obrigado desde já.<BR /></SPAN></P><P><IMG alt="Media de pedidos por mes.png" class="jive-image image-2" src="/legacyfs/online/147314_Media de pedidos por mes.png" style="height: 349px; width: 620px;" /></P><P></P><P></P><P><IMG __jive_id="147306" alt="DashboardEx2Temporario.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/147306_DashboardEx2Temporario.png" style="height: 357px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Duvida-com-AVG/m-p/1219908#M863210 2020-11-25T16:16:04Z Re: Duvida com AVG https://community.qlik.com/t5/QlikView/Duvida-com-AVG/m-p/1219909#M863211 <HTML><HEAD></HEAD><BODY><P>Maybe use....</P><P></P><P>Sum(SalesOrderID)/ count({&lt;YourDimensionsHere&gt;} Total<SPAN style="font-style: inherit; font-family: inherit;"><STRONG> </STRONG></SPAN>distinct Mes)</P><P></P><P>What number are you expecting as average?</P><P></P><P>Check the below link and search same in community</P><P><A href="https://community.qlik.com/thread/59651">Calculate average pr month</A></P></BODY></HTML> Wed, 21 Dec 2016 20:24:51 GMT https://community.qlik.com/t5/QlikView/Duvida-com-AVG/m-p/1219909#M863211 MK9885 2016-12-21T20:24:51Z Re: Duvida com AVG https://community.qlik.com/t5/QlikView/Duvida-com-AVG/m-p/1219910#M863212 <HTML><HEAD></HEAD><BODY><P>This expression Satisfied my <SPAN style="color: #000000; font-family: arial, sans-serif; font-size: 13px; text-decoration: underline;">necessity</SPAN></P><TABLE class="gt-baf-table" style="color: #777777; font-family: arial, sans-serif; font-size: 13px;"><TBODY><TR><TD colspan="2"><P class="gt-baf-cell"></P></TD><TD>=Count({1&lt;Ano = {$(=Max(Ano))}&gt;}DISTINCT SalesOrderID) / 12</TD></TR></TBODY></TABLE><P></P><P>thx for the comment. </P></BODY></HTML> Thu, 22 Dec 2016 20:35:55 GMT https://community.qlik.com/t5/QlikView/Duvida-com-AVG/m-p/1219910#M863212 2016-12-22T20:35:55Z