topic Re: Mudar cor pontos google cluster in Brasil https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442077#M52914 <HTML><HEAD></HEAD><BODY><P>Alessandro uma duvida. Estou tentando fazer a formula parque que valores maiores que 500 fiquem vermelho</P><P>e menores que 500 fiquem azul.</P><P>Mas só está me retornando a cor vermelha</P><P></P><P><SPAN>=if(sum(VALOR_VENDIDO)&gt;500,'</SPAN><A class="jive-link-external-small" href="http://maps.google.com/mapfiles/ms/icons/red-dot.png" rel="nofollow" target="_blank">http://maps.google.com/mapfiles/ms/icons/red-dot.png</A><SPAN>',</SPAN></P><P><SPAN>if(sum(VALOR_VENDIDO)&lt;500,'</SPAN><A class="jive-link-external-small" href="http://maps.google.com/mapfiles/ms/icons/green-dot.png','http://maps.google.com/mapfiles/ms/icons/blue-dot.png" rel="nofollow" target="_blank">http://maps.google.com/mapfiles/ms/icons/green-dot.png','http://maps.google.com/mapfiles/ms/icons/blue-dot.png</A><SPAN>'))</SPAN></P></BODY></HTML> Fri, 29 Sep 2017 16:15:26 GMT fmbrancher 2017-09-29T16:15:26Z Mudar cor pontos google cluster https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442072#M52909 <HTML><HEAD></HEAD><BODY><P>Bom dia pessoal.<BR />Estou com um mapa criado a partida extensão do google cluster.<BR />Mas queria conseguir mudar as cores dos pontos.</P><P>Hoje meu mapa está assim:</P><P><IMG alt="latlong.jpg" class="jive-image image-1" height="294" src="https://community.qlik.com/legacyfs/online/178157_latlong.jpg" style="height: 294px; width: 393.693px;" width="394" /></P><P>e gostaria de mudar os pontos para algo parecido com isso.<BR />estou usando no measurement a fórmula =num(Sum (QUANTIDADE_VENDIDA),'#00')</P><P></P><P></P><P><IMG alt="cluster.PNG" class="jive-image image-2" height="460" src="https://community.qlik.com/legacyfs/online/178158_cluster.PNG" style="height: 460.499px; width: 371px;" width="371" /></P><P>Obrigado!!!</P></BODY></HTML> Fri, 29 Sep 2017 12:52:10 GMT https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442072#M52909 fmbrancher 2017-09-29T12:52:10Z Re: Mudar cor pontos google cluster https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442073#M52910 <HTML><HEAD></HEAD><BODY><P>Você teria que alterar o Script.js (código javascript que constrói o gráfico)</P></BODY></HTML> Fri, 29 Sep 2017 12:58:43 GMT https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442073#M52910 Clever_Anjos 2017-09-29T12:58:43Z Re: Mudar cor pontos google cluster https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442074#M52911 <HTML><HEAD></HEAD><BODY><P>Aqui está o link para o github do desenvolvedor, talvez ele possa te explicar onde alterar</P><P><A href="https://github.com/mindspank/GoogleMaps-Cluster-QV11" title="https://github.com/mindspank/GoogleMaps-Cluster-QV11">GitHub - mindspank/GoogleMaps-Cluster-QV11: QlikView 11 extension object.</A></P></BODY></HTML> Fri, 29 Sep 2017 13:00:33 GMT https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442074#M52911 Clever_Anjos 2017-09-29T13:00:33Z Re: Mudar cor pontos google cluster https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442075#M52912 <HTML><HEAD></HEAD><BODY><P><IMG alt="2017-09-29 11_28_06-QlikView x64 - [Farol Mapas Demo.qvw].png" class="jive-image image-1" src="/legacyfs/online/178182_2017-09-29 11_28_06-QlikView x64 - [Farol Mapas Demo.qvw].png" style="height: 348px; width: 620px;" /></P><P></P><P>exemplo....</P><P></P><P><SPAN>=if(Marcador_Cor=1,'</SPAN><A class="jive-link-external-small" href="http://maps.google.com/mapfiles/ms/icons/red-dot.png" rel="nofollow" target="_blank">http://maps.google.com/mapfiles/ms/icons/red-dot.png</A><SPAN>',</SPAN></P><P><SPAN>if(Marcador_Cor=2,'</SPAN><A class="jive-link-external-small" href="http://maps.google.com/mapfiles/ms/icons/green-dot.png','http://maps.google.com/mapfiles/ms/icons/blue-dot.png" rel="nofollow" target="_blank">http://maps.google.com/mapfiles/ms/icons/green-dot.png','http://maps.google.com/mapfiles/ms/icons/blue-dot.png</A><SPAN>'))</SPAN></P></BODY></HTML> Fri, 29 Sep 2017 14:49:40 GMT https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442075#M52912 afurtado 2017-09-29T14:49:40Z Re: Mudar cor pontos google cluster https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442076#M52913 <HTML><HEAD></HEAD><BODY><P>Obrigado Alessando.</P></BODY></HTML> Fri, 29 Sep 2017 16:07:44 GMT https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442076#M52913 fmbrancher 2017-09-29T16:07:44Z Re: Mudar cor pontos google cluster https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442077#M52914 <HTML><HEAD></HEAD><BODY><P>Alessandro uma duvida. Estou tentando fazer a formula parque que valores maiores que 500 fiquem vermelho</P><P>e menores que 500 fiquem azul.</P><P>Mas só está me retornando a cor vermelha</P><P></P><P><SPAN>=if(sum(VALOR_VENDIDO)&gt;500,'</SPAN><A class="jive-link-external-small" href="http://maps.google.com/mapfiles/ms/icons/red-dot.png" rel="nofollow" target="_blank">http://maps.google.com/mapfiles/ms/icons/red-dot.png</A><SPAN>',</SPAN></P><P><SPAN>if(sum(VALOR_VENDIDO)&lt;500,'</SPAN><A class="jive-link-external-small" href="http://maps.google.com/mapfiles/ms/icons/green-dot.png','http://maps.google.com/mapfiles/ms/icons/blue-dot.png" rel="nofollow" target="_blank">http://maps.google.com/mapfiles/ms/icons/green-dot.png','http://maps.google.com/mapfiles/ms/icons/blue-dot.png</A><SPAN>'))</SPAN></P></BODY></HTML> Fri, 29 Sep 2017 16:15:26 GMT https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442077#M52914 fmbrancher 2017-09-29T16:15:26Z Re: Mudar cor pontos google cluster https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442078#M52915 <HTML><HEAD></HEAD><BODY><P>Quem sabe colocando um aggr() por cliente?</P></BODY></HTML> Fri, 29 Sep 2017 16:38:36 GMT https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442078#M52915 afurtado 2017-09-29T16:38:36Z Re: Mudar cor pontos google cluster https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442079#M52916 <HTML><HEAD></HEAD><BODY><P>Alessandro, caso o amigo esteja vendo...</P><P><A _jive_internal="true" href="https://community.qlik.com/message/1354021#1354021">https://community.qlik.com/message/1354021#1354021</A></P></BODY></HTML> Fri, 29 Sep 2017 16:49:39 GMT https://community.qlik.com/t5/Brasil/Mudar-cor-pontos-google-cluster/m-p/1442079#M52916 Ribeiro 2017-09-29T16:49:39Z