topic Re: Subtotal Tabela Deviation CR in Brasil https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117034#M6367 <HTML><HEAD></HEAD><BODY><P>Tentei também, aí esta coluna fica com o mesmo problema anterior da outra coluna... o resultado fica 36%....</P></BODY></HTML> Tue, 24 Jul 2018 19:47:10 GMT Anonymous 2018-07-24T19:47:10Z Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117028#M6361 <HTML><HEAD></HEAD><BODY><P><IMG alt="deviation.JPG" class="jive-image image-1" height="386" src="https://community.qlik.com/legacyfs/online/208581_deviation.JPG" style="width: 383px; height: 298px;" width="524" /></P><P>Olá amigos, boa tarde!</P><P></P><P>Tenho uma tabela com 2 colunas com subtotais e uma terceira coluna que seria a somatória da diferença de todos os itens, porém eu gostaria qu o subtotal, realmente somasse todos os itens, mas na verdade ele está mostrando apenas a subtração das colunas "Request - Forecast". Alguém poderia me auxiliar com este caso, por gentileza?</P><P></P><P>Está fazendo isso: 16158 (Request) - 10374 (Forecast) = 5784</P><P>O que preciso: Somatória de todos os itens da coluna "Deviation" que seria =13286</P><P></P><P>Desde já agradeço a atenção, forte abraço</P><P>Cristiano Lima</P></BODY></HTML> Mon, 23 Jul 2018 18:36:43 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117028#M6361 Anonymous 2018-07-23T18:36:43Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117029#M6362 <HTML><HEAD></HEAD><BODY><P>Cristiano,</P><P></P><P>Na coluna Deviation use:</P><P></P><P>If(Dimensionality()=0,RangeSum(REQUEST,-FORECAST),</P><P>&nbsp;&nbsp;&nbsp;&nbsp; FORECAST-REQUEST</P><P>)</P></BODY></HTML> Mon, 23 Jul 2018 20:06:50 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117029#M6362 Thiago_Justen_ 2018-07-23T20:06:50Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117030#M6363 <HTML><HEAD></HEAD><BODY><P>Oi Thiago, bom dia!</P><P></P><P>Obrigado pelo retorno!</P><P>Tentei desta forma, mas não mudou o resultado... (acrescentei apenas o "Fabs" na fórmula para desconsiderar sinal positivo ou negativo e retornar o valor absoluto). Veja como ficou...</P><P><IMG alt="deviation2.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208667_deviation2.JPG" style="width: 500px; height: 237px;" /></P></BODY></HTML> Tue, 24 Jul 2018 11:29:57 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117030#M6363 Anonymous 2018-07-24T11:29:57Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117031#M6364 <HTML><HEAD></HEAD><BODY><P>Isso ajuda?</P><P><IMG alt="Capturar.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208706_Capturar.PNG" style="height: 519px; width: 620px;" /></P></BODY></HTML> Tue, 24 Jul 2018 16:36:22 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117031#M6364 Thiago_Justen_ 2018-07-24T16:36:22Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117032#M6365 <HTML><HEAD></HEAD><BODY><P>Oi Thiago,</P><P></P><P>Opa ajudou sim, obrigado!!! Uma outra dúvida... Agora na última coluna "% Deviation", essa é a soma de Deviation / Request, o resultado deveria ser = 82%.<IMG alt="deviation3.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208708_deviation3.JPG" style="width: 620px; height: 234px;" /></P></BODY></HTML> Tue, 24 Jul 2018 18:31:22 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117032#M6365 Anonymous 2018-07-24T18:31:22Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117033#M6366 <HTML><HEAD></HEAD><BODY><P>Marque a flag "Total da Expressão".</P></BODY></HTML> Tue, 24 Jul 2018 19:34:09 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117033#M6366 Thiago_Justen_ 2018-07-24T19:34:09Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117034#M6367 <HTML><HEAD></HEAD><BODY><P>Tentei também, aí esta coluna fica com o mesmo problema anterior da outra coluna... o resultado fica 36%....</P></BODY></HTML> Tue, 24 Jul 2018 19:47:10 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117034#M6367 Anonymous 2018-07-24T19:47:10Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117035#M6368 <HTML><HEAD></HEAD><BODY><P>Qual a expressão que você tá usando? Acaso usou&nbsp; a mesma lógica do Dimensionality()=0?</P></BODY></HTML> Tue, 24 Jul 2018 19:50:07 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117035#M6368 Thiago_Justen_ 2018-07-24T19:50:07Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117036#M6369 <HTML><HEAD></HEAD><BODY><P>Na verdade usei a mesma fórmula que estava usando... apenas mudando de tabela dinâmica para tabela simples e flegando "Soma" a coluna anterior ficou correta..</P><P></P><P>Coluna "Devition" = fómula: =FABS(REQUEST-(FORECAST))</P><P>Coluna "% Deviation" = fórmula: =IF(REQUEST=0,'100%',DEVIATION/REQUEST)</P></BODY></HTML> Tue, 24 Jul 2018 19:57:38 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117036#M6369 Anonymous 2018-07-24T19:57:38Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117037#M6370 <HTML><HEAD></HEAD><BODY><P>Teste:</P><P>IF(Dimensionality()=0,Sum(total DEVIATION)/Sum(total REQUEST),</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IF(REQUEST=0,'100%',DEVIATION/REQUEST)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">)<BR /></SPAN></P></BODY></HTML> Tue, 24 Jul 2018 20:08:53 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117037#M6370 Thiago_Justen_ 2018-07-24T20:08:53Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117038#M6371 <HTML><HEAD></HEAD><BODY><P>Oi Thiago, bom dia!</P><P></P><P>Ainda não deu certo...</P><P></P><P>Flegando "Total da expressão"...</P><P><IMG alt="deviation4.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208795_deviation4.JPG" style="width: 620px; height: 239px;" /></P><P>Flegando "Soma"...</P><P><IMG alt="deviation5.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/208802_deviation5.JPG" style="width: 620px; height: 189px;" /></P></BODY></HTML> Wed, 25 Jul 2018 11:13:04 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117038#M6371 Anonymous 2018-07-25T11:13:04Z Re: Subtotal Tabela Deviation CR https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117039#M6372 <HTML><HEAD></HEAD><BODY><P>Bom dia galera!</P><P></P><P>Alguém pode me dar um help com este tema, realmente não consigo achar uma solução!</P><P></P><P>Desde já agradeço a atenção</P><P>Forte abraço.</P></BODY></HTML> Thu, 26 Jul 2018 12:46:27 GMT https://community.qlik.com/t5/Brasil/Subtotal-Tabela-Deviation-CR/m-p/117039#M6372 Anonymous 2018-07-26T12:46:27Z