topic Ranges in Brasil https://community.qlik.com/t5/Brasil/Ranges/m-p/731623#M21804 <HTML><HEAD></HEAD><BODY><P>Bom Dia Pessoal</P><P></P><P>alguem ja fez um tabela de range&nbsp; ?</P><P></P><P></P><P></P><P>Estava tentando fazer aqui mas ta saindo semrpe o mesmo valor por mais que&nbsp; coloque a condição do Set analisys </P><P></P><P></P><P>=&nbsp;&nbsp;&nbsp; ((Count(&nbsp; {&lt; [qtd] =&nbsp; {'= 1'} &gt; } [qtd] ) ) / count( DISTINCT [Documento]))&nbsp; estou fazendo isso mas sempre retorna o mesmo valor se eu colocar qtd&nbsp; = 2 ou 3 e assim por diante</P></BODY></HTML> Thu, 30 Oct 2014 11:01:04 GMT 2014-10-30T11:01:04Z Ranges https://community.qlik.com/t5/Brasil/Ranges/m-p/731623#M21804 <HTML><HEAD></HEAD><BODY><P>Bom Dia Pessoal</P><P></P><P>alguem ja fez um tabela de range&nbsp; ?</P><P></P><P></P><P></P><P>Estava tentando fazer aqui mas ta saindo semrpe o mesmo valor por mais que&nbsp; coloque a condição do Set analisys </P><P></P><P></P><P>=&nbsp;&nbsp;&nbsp; ((Count(&nbsp; {&lt; [qtd] =&nbsp; {'= 1'} &gt; } [qtd] ) ) / count( DISTINCT [Documento]))&nbsp; estou fazendo isso mas sempre retorna o mesmo valor se eu colocar qtd&nbsp; = 2 ou 3 e assim por diante</P></BODY></HTML> Thu, 30 Oct 2014 11:01:04 GMT https://community.qlik.com/t5/Brasil/Ranges/m-p/731623#M21804 2014-10-30T11:01:04Z Re: Ranges https://community.qlik.com/t5/Brasil/Ranges/m-p/731624#M21805 <HTML><HEAD></HEAD><BODY><P>=&nbsp;&nbsp;&nbsp; ((Count(&nbsp; {&lt; [qtd] =&nbsp; {'1'} &gt; } [qtd] ) ) / count( DISTINCT [Documento])) </P></BODY></HTML> Thu, 30 Oct 2014 11:07:02 GMT https://community.qlik.com/t5/Brasil/Ranges/m-p/731624#M21805 MK_QSL 2014-10-30T11:07:02Z Re: Ranges https://community.qlik.com/t5/Brasil/Ranges/m-p/731625#M21806 <HTML><HEAD></HEAD><BODY><P>Assim deveria funcionar?</P><P></P><P>((Count(&nbsp; {&lt; [Qtd] =&nbsp; {'&lt;=1&nbsp; &lt;2'} &gt; } [Qtd]&nbsp; ) ) / count( DISTINCT [Documento]))</P></BODY></HTML> Thu, 30 Oct 2014 11:13:52 GMT https://community.qlik.com/t5/Brasil/Ranges/m-p/731625#M21806 2014-10-30T11:13:52Z Re: Ranges https://community.qlik.com/t5/Brasil/Ranges/m-p/731626#M21807 <HTML><HEAD></HEAD><BODY><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f6f6f6;">((Count(&nbsp; {&lt; [Qtd] =&nbsp; {'&gt;=1 &lt; 2'} &gt; } [Qtd]&nbsp; ) ) / count( DISTINCT [Documento]))</P></BODY></HTML> Thu, 30 Oct 2014 11:49:36 GMT https://community.qlik.com/t5/Brasil/Ranges/m-p/731626#M21807 MK_QSL 2014-10-30T11:49:36Z