topic Re: AVG of SUM in Brasil https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460978#M53745 <HTML><HEAD></HEAD><BODY><P>Clever o que seria o Dimensionality?</P></BODY></HTML> Mon, 08 Jan 2018 20:02:42 GMT antoniodneto 2018-01-08T20:02:42Z AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460972#M53739 <HTML><HEAD></HEAD><BODY><P>Boa tarde amigos,</P><P></P><P>Tenho um campo calculado :</P><P></P><P>SUM(EAD_PD)</P><P>/</P><P>SUM(exposicao)</P><P></P><P>Normal trago o percentual de cada mês da minha base corretamente, porém ao colocar a linha TOTAIS, ele faz a soma desses percentuais que está errado, eu preciso calcular a média desse cálculo de sum.</P><P></P><P>Consigo criar um AVG(SUM(......&nbsp; ?</P><P></P><P></P><P>Obrigado</P></BODY></HTML> Mon, 08 Jan 2018 19:21:55 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460972#M53739 antoniodneto 2018-01-08T19:21:55Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460973#M53740 <HTML><HEAD></HEAD><BODY><P>Talvez ajude : <A href="https://community.qlik.com/qlik-blogpost/5474">Totais em gráficos</A></P></BODY></HTML> Mon, 08 Jan 2018 19:34:44 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460973#M53740 Clever_Anjos 2018-01-08T19:34:44Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460974#M53741 <HTML><HEAD></HEAD><BODY><P>Oi Clever, não consegui aplicar as dicas do post</P></BODY></HTML> Mon, 08 Jan 2018 19:39:59 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460974#M53741 antoniodneto 2018-01-08T19:39:59Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460975#M53742 <HTML><HEAD></HEAD><BODY><P>Antonio, disponibiliza teu app que a gente tenta ajudar.</P><P></P><P>Abs e Sucesso!</P></BODY></HTML> Mon, 08 Jan 2018 19:41:17 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460975#M53742 Thiago_Justen_ 2018-01-08T19:41:17Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460976#M53743 <P>Segue Thiago,</P><P>&nbsp;</P><P>Na tabela dinâmica o Totais, gostaria&nbsp; que me mostrasse a média desses percentuais.</P><P>&nbsp;</P><P>E no gráfico de linha a mesma coisa, seria a média dos percentuais.</P><P>&nbsp;</P><P>&nbsp;</P><P>Obrigado pela ajuda</P> Fri, 15 Mar 2019 14:38:48 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460976#M53743 antoniodneto 2019-03-15T14:38:48Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460977#M53744 <HTML><HEAD></HEAD><BODY><P>Lá no exemplo</P><P>IF(Dimensionality() =0 , // Totais</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; formula da media,</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">SUM(EAD_PD)</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">/</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">SUM(exposicao)</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">)</P></BODY></HTML> Mon, 08 Jan 2018 19:53:50 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460977#M53744 Clever_Anjos 2018-01-08T19:53:50Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460978#M53745 <HTML><HEAD></HEAD><BODY><P>Clever o que seria o Dimensionality?</P></BODY></HTML> Mon, 08 Jan 2018 20:02:42 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460978#M53745 antoniodneto 2018-01-08T20:02:42Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460979#M53746 <HTML><HEAD></HEAD><BODY><P>é uma função do Qlik que diz em que nível da sua tabela dinamica você está</P><P>0 = totalizador geral</P><P>1 - 1o nivel de agregacao </P><P>etc</P><P></P><P><A href="https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/ChartFunctions/InterRecordFunctions/dimensionality.htm" title="https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/ChartFunctions/InterRecordFunctions/dimensionality.htm">https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/ChartFunctions/InterRecordFunctions/dimensionality…</A></P></BODY></HTML> Mon, 08 Jan 2018 20:14:12 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460979#M53746 Clever_Anjos 2018-01-08T20:14:12Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460980#M53747 <HTML><HEAD></HEAD><BODY><P>Não estou conseguindo.</P><P></P><P>E no gráfico de linhas, é possível colocar a média?</P><P></P><P>Abs</P></BODY></HTML> Mon, 08 Jan 2018 20:33:30 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460980#M53747 antoniodneto 2018-01-08T20:33:30Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460981#M53748 <HTML><HEAD></HEAD><BODY><P>Antonio,</P><P></P><P> Utilize a função AGGR para fazer um AVG sobre o sum.</P><P>AVG(AGGR(SUM(&lt;expressão&gt;), campo dimensão1, campo dimensão2, ...))</P><P></P><P>Caso não conheça como o AGGR funciona, dá uma olhada&nbsp; primeiro no meu post para entender o conceito do AGGR e depois você aplica no seu app.</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/5498">Combinando qualificador TOTAL e AGGR</A></P><P></P><P>Abraço,</P><P></P><P>Pablo</P></BODY></HTML> Tue, 09 Jan 2018 01:58:39 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460981#M53748 pablolabbe 2018-01-09T01:58:39Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460982#M53749 <HTML><HEAD></HEAD><BODY><P>Recomendo sempre enviar uma app bem pequena com somente uma amostra dos dados para exemplificar. Você envio um app completo com 14 mb com dados que podem ser confidenciais da sua empresa. Muito cuidado ao compartilhar apps pois qualquer um com qlik sense pode abrir e fazer uso indevido deles.</P><P></P><P>Att,</P><P></P><P>Pablo</P></BODY></HTML> Tue, 09 Jan 2018 02:01:13 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460982#M53749 pablolabbe 2018-01-09T02:01:13Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460983#M53750 <HTML><HEAD></HEAD><BODY><P>Sense ou Qlikview?</P></BODY></HTML> Tue, 09 Jan 2018 09:36:57 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460983#M53750 Clever_Anjos 2018-01-09T09:36:57Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460984#M53751 <HTML><HEAD></HEAD><BODY><P>Sense</P></BODY></HTML> Tue, 09 Jan 2018 12:04:10 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460984#M53751 antoniodneto 2018-01-09T12:04:10Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460985#M53752 <HTML><HEAD></HEAD><BODY><P>Deixa ver se entendi,</P><P>Você quer em um gráfico de linhas no Sense mostrar uma outra linha com a média, correto?</P><P>Tente usar uma linha referência para isso</P><P><IMG alt="Capturar.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/189417_Capturar.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 09 Jan 2018 12:13:40 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460985#M53752 Clever_Anjos 2018-01-09T12:13:40Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460986#M53753 <HTML><HEAD></HEAD><BODY><P>Pablo,</P><P></P><P>Eu li o post mas não estou conseguindo aplicar na expressão como eu preciso.</P><P></P><P>Estou utilizando dessa maneira avg(Aggr(sum(EAD_PD)/sum(exposicao),anomes))</P><P>Não sei se está correto.</P><P></P><P></P><P>Abs</P></BODY></HTML> Tue, 09 Jan 2018 12:28:39 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460986#M53753 antoniodneto 2018-01-09T12:28:39Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460987#M53754 <HTML><HEAD></HEAD><BODY><P>Qual o resultado da expressão ? mande um print</P></BODY></HTML> Tue, 09 Jan 2018 13:08:21 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460987#M53754 pablolabbe 2018-01-09T13:08:21Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460989#M53756 <HTML><HEAD></HEAD><BODY><P>Boa tarde Antonio, como vai?</P><P></P><P>Passa assim:</P><P>avg(Aggr(sum(EAD_PD)/sum(exposicao),anomes,FX_VAL))</P><P><IMG alt="Erro.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/189458_Erro.png" style="height: 266px; width: 620px;" /></P></BODY></HTML> Tue, 09 Jan 2018 15:59:11 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460989#M53756 marcelvinicius 2018-01-09T15:59:11Z Re: AVG of SUM https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460990#M53757 <HTML><HEAD></HEAD><BODY><P>PERFEITO MARCEL!!!</P><P></P><P>Faltou a dimensão do FX_VAL.</P><P></P><P></P><P>Muito obrigado!!!!</P></BODY></HTML> Tue, 09 Jan 2018 16:06:04 GMT https://community.qlik.com/t5/Brasil/AVG-of-SUM/m-p/1460990#M53757 antoniodneto 2018-01-09T16:06:04Z