topic Re: Set Analysis - Últ Registro in Brasil https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119192#M6479 <HTML><HEAD></HEAD><BODY><P>Editei a expressão para contar '<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Contato Sem Sucesso'</STRONG></P></BODY></HTML> Fri, 31 Aug 2018 20:00:49 GMT Thiago_Justen_ 2018-08-31T20:00:49Z Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119179#M6466 <HTML><HEAD></HEAD><BODY><P>Boa noite, Pessoal</P><P></P><P>Preciso realizar a seguinte proeza:</P><P></P><P>Tenho quatro respostas (<SPAN style="font-size: 13.3333px;">Bloqueio Sem Contato, <SPAN style="font-size: 13.3333px;">Bloqueio Sem Contato 1, <SPAN style="font-size: 13.3333px;">Bloqueio Sem Contato 2, <SPAN style="font-size: 13.3333px;">Bloqueio Sem Contato 3</SPAN></SPAN></SPAN></SPAN>) e preciso contar de maneira distinta por cliente.</P><P></P><P>Por exemplo, um cliente ao longo do dia pode ter respondido <SPAN style="font-size: 13.3333px;">Bloqueio Sem Contato </SPAN>pela manhã e <SPAN style="font-size: 13.3333px;">Bloqueio Sem Contato 1</SPAN> no final do dia,mas n<SPAN style="font-size: 10pt;">a minha contagem só posso considerar sempre a última resposta. No caso, <SPAN style="font-size: 13.3333px;">Bloqueio Sem Contato 1</SPAN> !</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG>KPI's</STRONG></SPAN></P><P><STRONG style="font-size: 13.3333px;">"Bloqueio Sem Contato 1" = 1</STRONG></P><P><SPAN style="font-size: 13.3333px;"><STRONG>"Bloqueio Sem Contato" = 0</STRONG></SPAN></P><P></P><P><STRONG>Campos Auxiliares</STRONG></P><P><STRONG>Data</STRONG></P><P><STRONG>ID Cliente</STRONG></P><P><STRONG>Resposta</STRONG></P></BODY></HTML> Thu, 23 Aug 2018 23:29:40 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119179#M6466 Anonymous 2018-08-23T23:29:40Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119180#M6467 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Felipe, Segue um QVW de exemplo.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Acredito que vai atender a sua necessidade!</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Atenciosamente,</SPAN></P></BODY></HTML> Fri, 24 Aug 2018 01:29:07 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119180#M6467 luizbezerra 2018-08-24T01:29:07Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119181#M6468 <HTML><HEAD></HEAD><BODY><P>Via UI podes fazer com a seguinte expressão:</P><P></P><P>FirstSortedvalue(Resposta,-Aggr(Data,Cliente,Data))</P></BODY></HTML> Fri, 24 Aug 2018 01:49:56 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119181#M6468 Thiago_Justen_ 2018-08-24T01:49:56Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119182#M6469 <HTML><HEAD></HEAD><BODY><P>Thiago,</P><P></P><P>Onde eu poderia encaixar uma forma que ele contasse para mim em um KPI ?</P><P></P><P>FirstSortedvalue(Count({&lt;resposta={"Contato"}&gt;} documento),-Aggr(Data_Registro,documento,Data_Registro))</P><P></P><P>tentei algumas formas aqui kk</P></BODY></HTML> Fri, 24 Aug 2018 14:01:34 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119182#M6469 Anonymous 2018-08-24T14:01:34Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119183#M6470 <HTML><HEAD></HEAD><BODY><P>Felippe,</P><P></P><P>Teste assim:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count({&lt;resposta={"=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FirstSortedvalue(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">resposta</SPAN>,-Aggr(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Data_Registro</SPAN>,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">documento</SPAN>,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Data_Registro</SPAN>))='<STRONG>Contato</STRONG>'</SPAN>"}&gt;}documento)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></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> Fri, 24 Aug 2018 14:10:53 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119183#M6470 Thiago_Justen_ 2018-08-24T14:10:53Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119184#M6471 <HTML><HEAD></HEAD><BODY><P>Thiago, </P><P></P><P>Tentei dessa forma e está dando 0 !</P><P></P><P>E a função <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FirstSortedvalue(Resposta,-Aggr(Data,Cliente,Data))</SPAN> não está retornando o último valor.</P><P></P><P><IMG alt="Capturar.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/211770_Capturar.PNG" style="height: 158px; width: 620px;" /></P></BODY></HTML> Fri, 24 Aug 2018 15:02:11 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119184#M6471 Anonymous 2018-08-24T15:02:11Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119185#M6472 <HTML><HEAD></HEAD><BODY><P>Você tem algum campo data/hora? Ou apenas os campos separados como na tabela?</P></BODY></HTML> Fri, 24 Aug 2018 18:28:11 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119185#M6472 Thiago_Justen_ 2018-08-24T18:28:11Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119186#M6473 <HTML><HEAD></HEAD><BODY><P>Thiago,</P><P></P><P>Sim, tenho um campo com data/hora.</P><P></P><P>Att,</P></BODY></HTML> Tue, 28 Aug 2018 17:05:55 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119186#M6473 Anonymous 2018-08-28T17:05:55Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119187#M6474 <HTML><HEAD></HEAD><BODY><P>Pessoal, </P><P></P><P>Alguma dica sobre esse problema ?</P><P></P><P>Ainda estou com ele !</P></BODY></HTML> Fri, 31 Aug 2018 19:24:10 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119187#M6474 Anonymous 2018-08-31T19:24:10Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119188#M6475 <HTML><HEAD></HEAD><BODY><P>Estou travado no seguinte tema.</P><P></P><P>Set da Contagem:</P><P><STRONG>Count({&lt;resposta={"=FirstSortedvalue(resposta,-Data_Hora)='Contato Sem Sucesso'"}&gt;}documento)</STRONG></P><P></P><P>Set da Últ Resp.</P><P><STRONG>FirstSortedvalue(resposta,-Data_Hora)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Imagem do problema !!!<BR /></STRONG></P><P><STRONG><IMG alt="Print.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/212398_Print.PNG" style="height: 154px; width: 620px;" /></STRONG></P><P>Hoje o problema da última resposta foi sanado graças à todos que ajudaram <A href="https://community.qlik.com/qlik-users/263751">thiago.justen</A>‌ e <A href="https://community.qlik.com/qlik-users/230492">luizbezerra</A>‌, mas estou com problema de contagem ... visto na imagem.</P><P></P><P>Obrigado !!</P></BODY></HTML> Fri, 31 Aug 2018 19:34:44 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119188#M6475 Anonymous 2018-08-31T19:34:44Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119189#M6476 <HTML><HEAD></HEAD><BODY><P>Desculpa...caiu no breu do esquecimento. Consegue compartilhar o qvf (ainda que com dados fictícios)?</P></BODY></HTML> Fri, 31 Aug 2018 19:35:10 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119189#M6476 Thiago_Justen_ 2018-08-31T19:35:10Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119190#M6477 <HTML><HEAD></HEAD><BODY><P>Talvez, isso funcione pro contador:</P><P></P><P><SPAN style="color: #666666; font-size: 10.5pt; font-family: 'Helvetica',sans-serif;"><STRONG>Aggr(Count({&lt;resposta={'<SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Contato Sem Sucesso</STRONG></SPAN>'}&gt;}distinct documento),FirstSortedValue(resposta,-Aggr(Data_Hora,documento)))</STRONG></SPAN></P><P><SPAN style="color: #666666; font-size: 10.5pt; font-family: 'Helvetica',sans-serif;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="text-decoration: underline; color: #0000ff;"><SPAN style="font-size: 10.5pt; font-family: Helvetica, sans-serif; text-decoration: underline;"><STRONG><BR /></STRONG></SPAN></SPAN></P><P><SPAN style="color: #666666; font-size: 10.5pt; font-family: 'Helvetica',sans-serif;"><STRONG><SPAN style="text-decoration: underline;"><SPAN style="color: #0000ff; text-decoration: underline;">Editado</SPAN></SPAN><BR /></STRONG></SPAN></P></BODY></HTML> Fri, 31 Aug 2018 19:40:42 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119190#M6477 Thiago_Justen_ 2018-08-31T19:40:42Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119191#M6478 <HTML><HEAD></HEAD><BODY><P>É realmente não funcionou <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Fri, 31 Aug 2018 19:55:36 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119191#M6478 Anonymous 2018-08-31T19:55:36Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119192#M6479 <HTML><HEAD></HEAD><BODY><P>Editei a expressão para contar '<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Contato Sem Sucesso'</STRONG></P></BODY></HTML> Fri, 31 Aug 2018 20:00:49 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119192#M6479 Thiago_Justen_ 2018-08-31T20:00:49Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119193#M6480 <HTML><HEAD></HEAD><BODY><P>Olá!</P><P></P><P>Se ainda está com problema, envia um QVF ou QVW de exemplo, pois sem saber como está o teu modelo de dados fica difícil.</P><P></P><P>Abraço.</P></BODY></HTML> Fri, 31 Aug 2018 20:29:14 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119193#M6480 aderlanrm 2018-08-31T20:29:14Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119194#M6481 <HTML><HEAD></HEAD><BODY><P>Não deu certo !</P><P></P><P>Vou enviar o arquivo, mas está com 90 mbs <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Fri, 31 Aug 2018 20:59:16 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119194#M6481 Anonymous 2018-08-31T20:59:16Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119195#M6482 <HTML><HEAD></HEAD><BODY><P>Segue !</P></BODY></HTML> Fri, 31 Aug 2018 21:14:54 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119195#M6482 Anonymous 2018-08-31T21:14:54Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119196#M6483 <HTML><HEAD></HEAD><BODY><P>Mandei lá !</P></BODY></HTML> Fri, 31 Aug 2018 21:15:35 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119196#M6483 Anonymous 2018-08-31T21:15:35Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119197#M6484 <HTML><HEAD></HEAD><BODY><P>Bom dia, </P><P></P><P>Alguém conseguiu algo ? </P><P></P><P>Att,</P></BODY></HTML> Mon, 03 Sep 2018 14:07:16 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119197#M6484 Anonymous 2018-09-03T14:07:16Z Re: Set Analysis - Últ Registro https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119198#M6485 <HTML><HEAD></HEAD><BODY><P>Felippe,</P><P></P><P>Segue resposta:</P><P></P><P>Sum(Aggr(If(FirstSortedValue(resposta,-Data_Hora)=<STRONG>'Contato Sem Sucesso'</STRONG>,1),documento))</P><P></P><P>Onde a parte em negrito deve ser editada conforme necessidade.</P><P></P><P>Abs e Sucesso!!</P></BODY></HTML> Mon, 03 Sep 2018 16:42:08 GMT https://community.qlik.com/t5/Brasil/Set-Analysis-%C3%9Alt-Registro/m-p/119198#M6485 Thiago_Justen_ 2018-09-03T16:42:08Z