<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic GIS -API manipulation. in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/GIS-API-manipulation/m-p/1025531#M939982</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I have GIS map and in the popup content I have below Hyperlink (HTML)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;a href="&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="http://www.abc.com/en-us/insights/research-the-market#?Keyword='&amp;amp;" rel="nofollow" target="_blank"&gt;http://www.abc.com/en-us/insights/research-the-market#?Keyword='&amp;amp;&lt;/A&gt;&lt;SPAN&gt;[&lt;/SPAN&gt;&lt;STRONG&gt;Market&lt;/STRONG&gt;]&amp;amp;'&amp;amp;FilterTypes=Research" class="btn btn-info btn-xs" target="_blank"&amp;gt;&amp;lt;/a&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;here Market is a column with different place and the link looks like below where Denver is one of the &lt;STRONG&gt;Market&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="http://www.colliers.com/en-us/insights/research-the-market#?Keyword=Denver&amp;amp;FilterTypes=Research" title="http://www.colliers.com/en-us/insights/research-the-market#?Keyword=Denver&amp;amp;FilterTypes=Research" target="_blank"&gt;http://www.abc.com/en-us/insights/research-the-market#?Keyword=Denver&amp;amp;FilterTypes=Research&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now I want to use the below hyperlink where &lt;STRONG&gt;Market&lt;/STRONG&gt; should be replaced by &lt;SPAN style="font-size: 13.3333px;"&gt;[&lt;/SPAN&gt;&lt;STRONG style="font-size: 13.3333px;"&gt;if(len(Cluster)&amp;lt;0,Market,Cluster)&lt;/STRONG&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;] where Cluster is another column with other places.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;SPAN&gt;&amp;lt;a href="&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="http://www.abc.com/en-us/insights/research-the-market#?Keyword='&amp;amp;" rel="nofollow" target="_blank"&gt;http://www.abc.com/en-us/insights/research-the-market#?Keyword='&amp;amp;&lt;/A&gt;&lt;SPAN&gt;[&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;STRONG style="font-size: 13.3333px;"&gt;if(len(Cluster)&amp;lt;0,Market,Cluster))&lt;/STRONG&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;]&amp;amp;'&amp;amp;FilterTypes=Research" class="btn btn-info btn-xs" target="_blank"&amp;gt;&amp;lt;/a&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;but that if is not working and the link looks like below&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;A href="http://www.colliers.com/en-us/insights/research-the-market#?Keyword=&amp;amp;FilterTypes=Research" title="http://www.colliers.com/en-us/insights/research-the-market#?Keyword=&amp;amp;FilterTypes=Research" target="_blank"&gt;http://www.abc.com/en-us/insights/research-the-market#?Keyword=&amp;amp;FilterTypes=Research&lt;/A&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;Thanks much&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 20 Nov 2020 18:02:30 GMT</pubDate>
    <dc:creator />
    <dc:date>2020-11-20T18:02:30Z</dc:date>
    <item>
      <title>GIS -API manipulation.</title>
      <link>https://community.qlik.com/t5/QlikView/GIS-API-manipulation/m-p/1025531#M939982</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I have GIS map and in the popup content I have below Hyperlink (HTML)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;a href="&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="http://www.abc.com/en-us/insights/research-the-market#?Keyword='&amp;amp;" rel="nofollow" target="_blank"&gt;http://www.abc.com/en-us/insights/research-the-market#?Keyword='&amp;amp;&lt;/A&gt;&lt;SPAN&gt;[&lt;/SPAN&gt;&lt;STRONG&gt;Market&lt;/STRONG&gt;]&amp;amp;'&amp;amp;FilterTypes=Research" class="btn btn-info btn-xs" target="_blank"&amp;gt;&amp;lt;/a&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;here Market is a column with different place and the link looks like below where Denver is one of the &lt;STRONG&gt;Market&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="http://www.colliers.com/en-us/insights/research-the-market#?Keyword=Denver&amp;amp;FilterTypes=Research" title="http://www.colliers.com/en-us/insights/research-the-market#?Keyword=Denver&amp;amp;FilterTypes=Research" target="_blank"&gt;http://www.abc.com/en-us/insights/research-the-market#?Keyword=Denver&amp;amp;FilterTypes=Research&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now I want to use the below hyperlink where &lt;STRONG&gt;Market&lt;/STRONG&gt; should be replaced by &lt;SPAN style="font-size: 13.3333px;"&gt;[&lt;/SPAN&gt;&lt;STRONG style="font-size: 13.3333px;"&gt;if(len(Cluster)&amp;lt;0,Market,Cluster)&lt;/STRONG&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;] where Cluster is another column with other places.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;SPAN&gt;&amp;lt;a href="&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="http://www.abc.com/en-us/insights/research-the-market#?Keyword='&amp;amp;" rel="nofollow" target="_blank"&gt;http://www.abc.com/en-us/insights/research-the-market#?Keyword='&amp;amp;&lt;/A&gt;&lt;SPAN&gt;[&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;STRONG style="font-size: 13.3333px;"&gt;if(len(Cluster)&amp;lt;0,Market,Cluster))&lt;/STRONG&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;]&amp;amp;'&amp;amp;FilterTypes=Research" class="btn btn-info btn-xs" target="_blank"&amp;gt;&amp;lt;/a&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;but that if is not working and the link looks like below&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;A href="http://www.colliers.com/en-us/insights/research-the-market#?Keyword=&amp;amp;FilterTypes=Research" title="http://www.colliers.com/en-us/insights/research-the-market#?Keyword=&amp;amp;FilterTypes=Research" target="_blank"&gt;http://www.abc.com/en-us/insights/research-the-market#?Keyword=&amp;amp;FilterTypes=Research&lt;/A&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;Thanks much&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 20 Nov 2020 18:02:30 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/GIS-API-manipulation/m-p/1025531#M939982</guid>
      <dc:creator />
      <dc:date>2020-11-20T18:02:30Z</dc:date>
    </item>
  </channel>
</rss>

