topic OpenLayers mapping - using set analysis in the collour expression in QlikView https://community.qlik.com/t5/QlikView/OpenLayers-mapping-using-set-analysis-in-the-collour-expression/m-p/469575#M175383 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>It appreas that the OpenLayers extension is not able to work with set analysis. Does anyone know how to get around this?</P><P></P><P>I want to use an expression similar to below. I have tried this in a table and the expression calculates fine, however it does not calculate in OpenLayers.</P><P></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>if((rank(sum({$&lt;[Performance_Date]=&gt;}total&lt;[Group Name]&gt; Hours)))&lt;=31,rgb(44,27,69), <BR /><BR />if((rank(sum(..... rgb(xx,xx,xx)....</P><P></P><P></P><P>Many thanks,</P><P></P><P>Isabel</P><P></P></BODY></HTML> Fri, 17 May 2013 07:23:01 GMT 2013-05-17T07:23:01Z OpenLayers mapping - using set analysis in the collour expression https://community.qlik.com/t5/QlikView/OpenLayers-mapping-using-set-analysis-in-the-collour-expression/m-p/469575#M175383 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>It appreas that the OpenLayers extension is not able to work with set analysis. Does anyone know how to get around this?</P><P></P><P>I want to use an expression similar to below. I have tried this in a table and the expression calculates fine, however it does not calculate in OpenLayers.</P><P></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>if((rank(sum({$&lt;[Performance_Date]=&gt;}total&lt;[Group Name]&gt; Hours)))&lt;=31,rgb(44,27,69), <BR /><BR />if((rank(sum(..... rgb(xx,xx,xx)....</P><P></P><P></P><P>Many thanks,</P><P></P><P>Isabel</P><P></P></BODY></HTML> Fri, 17 May 2013 07:23:01 GMT https://community.qlik.com/t5/QlikView/OpenLayers-mapping-using-set-analysis-in-the-collour-expression/m-p/469575#M175383 2013-05-17T07:23:01Z