topic Repetir os valores in Brasil https://community.qlik.com/t5/Brasil/Repetir-os-valores/m-p/479102#M13509 <HTML><HEAD></HEAD><BODY><P>Como posso fazer para deixar de aparecer o ' - ' e aparecer o valor?</P><P>No meu caso até o 39 tem que aparecer 29,75, depois até o 49,75 aparecer 39 e depois completar com 49,75</P><P><IMG alt="media.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/46904_media.JPG.jpg" /></P></BODY></HTML> Wed, 25 Sep 2013 17:47:01 GMT 2013-09-25T17:47:01Z Repetir os valores https://community.qlik.com/t5/Brasil/Repetir-os-valores/m-p/479102#M13509 <HTML><HEAD></HEAD><BODY><P>Como posso fazer para deixar de aparecer o ' - ' e aparecer o valor?</P><P>No meu caso até o 39 tem que aparecer 29,75, depois até o 49,75 aparecer 39 e depois completar com 49,75</P><P><IMG alt="media.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/46904_media.JPG.jpg" /></P></BODY></HTML> Wed, 25 Sep 2013 17:47:01 GMT https://community.qlik.com/t5/Brasil/Repetir-os-valores/m-p/479102#M13509 2013-09-25T17:47:01Z Re: Repetir os valores https://community.qlik.com/t5/Brasil/Repetir-os-valores/m-p/479103#M13510 <HTML><HEAD></HEAD><BODY><P>sum(TOTAL &lt;campo&gt; valor) / Count(TOTAL &lt;campo&gt; valor)</P></BODY></HTML> Wed, 25 Sep 2013 17:53:47 GMT https://community.qlik.com/t5/Brasil/Repetir-os-valores/m-p/479103#M13510 Clever_Anjos 2013-09-25T17:53:47Z Re: Repetir os valores https://community.qlik.com/t5/Brasil/Repetir-os-valores/m-p/479104#M13511 <HTML><HEAD></HEAD><BODY><P>Tente Assim:</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>If(RowNo()=1,</P> <P> Aggr(sum(valor)/count(valor),campo),</P> <P> Above(Column(2)))</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE></BODY></HTML> Wed, 25 Sep 2013 17:59:46 GMT https://community.qlik.com/t5/Brasil/Repetir-os-valores/m-p/479104#M13511 rphpacheco 2013-09-25T17:59:46Z Re: Repetir os valores https://community.qlik.com/t5/Brasil/Repetir-os-valores/m-p/479105#M13512 <HTML><HEAD></HEAD><BODY><P>Valeuuu Clever!!!! Funcionou perfeitamente</P></BODY></HTML> Wed, 25 Sep 2013 18:25:05 GMT https://community.qlik.com/t5/Brasil/Repetir-os-valores/m-p/479105#M13512 2013-09-25T18:25:05Z