<?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 API Script in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/API-Script/m-p/1025465#M940011</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;We are using GIS -API and I have the below hyperlink in the Popup content&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-us/insights/research-the-market#?Keyword='&amp;amp;" rel="nofollow"&gt;http://www.abc.com-us/insights/research-the-market#?Keyword='&amp;amp;&lt;/A&gt;&lt;SPAN&gt; [&lt;/SPAN&gt;&lt;STRONG&gt;(if(Cluster=null(),Market,Cluster))&lt;/STRONG&gt;]&amp;amp;'&amp;amp;FilterTypes=Research" class="btn btn-info btn-xs" target="_blank"&amp;gt;View abc &amp;lt;/a&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here if I give as below it works fine&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&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-us/insights/research-the-market#?Keyword='&amp;amp;" rel="nofollow"&gt;http://www.abc.com-us/insights/research-the-market#?Keyword='&amp;amp;&lt;/A&gt;&lt;SPAN&gt; [&lt;/SPAN&gt;&lt;STRONG&gt;Cluster&lt;/STRONG&gt;]&amp;amp;'&amp;amp;FilterTypes=Research" class="btn btn-info btn-xs" target="_blank"&amp;gt;View abc &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;Cluster and Market are 2 fields in the data file and when I use just Cluster my hyperlink shows as below.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;Ex:Here Cluster is Washington,DC.&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; line-height: 1.5em;"&gt;&lt;A class="jive-link-external-small" href="http://www.abc.com/en-us/insights/research-the-market#?Keyword=Washington" rel="nofollow"&gt;http://www.abc.com/en-us/insights/research-the-market#?Keyword=Washington&lt;/A&gt;&lt;SPAN&gt;, DC&amp;amp;FilterTypes=Research&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;and when I use &lt;SPAN style="font-size: 13.3333px;"&gt;[&lt;/SPAN&gt;&lt;STRONG style="font-size: 13.3333px;"&gt;(if(Cluster=null(),Market,Cluster))&lt;/STRONG&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;]&lt;/SPAN&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;it is not doing the filtering logic and hence the hyperlink looks as 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"&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;When the cluster is blank I want this hyperlink to pick the Value from Market column.How can I achieve that ?&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;/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;BR /&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;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 02 Feb 2016 02:41:07 GMT</pubDate>
    <dc:creator />
    <dc:date>2016-02-02T02:41:07Z</dc:date>
    <item>
      <title>API Script</title>
      <link>https://community.qlik.com/t5/QlikView/API-Script/m-p/1025465#M940011</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;We are using GIS -API and I have the below hyperlink in the Popup content&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-us/insights/research-the-market#?Keyword='&amp;amp;" rel="nofollow"&gt;http://www.abc.com-us/insights/research-the-market#?Keyword='&amp;amp;&lt;/A&gt;&lt;SPAN&gt; [&lt;/SPAN&gt;&lt;STRONG&gt;(if(Cluster=null(),Market,Cluster))&lt;/STRONG&gt;]&amp;amp;'&amp;amp;FilterTypes=Research" class="btn btn-info btn-xs" target="_blank"&amp;gt;View abc &amp;lt;/a&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here if I give as below it works fine&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&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-us/insights/research-the-market#?Keyword='&amp;amp;" rel="nofollow"&gt;http://www.abc.com-us/insights/research-the-market#?Keyword='&amp;amp;&lt;/A&gt;&lt;SPAN&gt; [&lt;/SPAN&gt;&lt;STRONG&gt;Cluster&lt;/STRONG&gt;]&amp;amp;'&amp;amp;FilterTypes=Research" class="btn btn-info btn-xs" target="_blank"&amp;gt;View abc &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;Cluster and Market are 2 fields in the data file and when I use just Cluster my hyperlink shows as below.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;Ex:Here Cluster is Washington,DC.&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; line-height: 1.5em;"&gt;&lt;A class="jive-link-external-small" href="http://www.abc.com/en-us/insights/research-the-market#?Keyword=Washington" rel="nofollow"&gt;http://www.abc.com/en-us/insights/research-the-market#?Keyword=Washington&lt;/A&gt;&lt;SPAN&gt;, DC&amp;amp;FilterTypes=Research&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;and when I use &lt;SPAN style="font-size: 13.3333px;"&gt;[&lt;/SPAN&gt;&lt;STRONG style="font-size: 13.3333px;"&gt;(if(Cluster=null(),Market,Cluster))&lt;/STRONG&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;]&lt;/SPAN&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;it is not doing the filtering logic and hence the hyperlink looks as 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"&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;When the cluster is blank I want this hyperlink to pick the Value from Market column.How can I achieve that ?&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;/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;BR /&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;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 02 Feb 2016 02:41:07 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/API-Script/m-p/1025465#M940011</guid>
      <dc:creator />
      <dc:date>2016-02-02T02:41:07Z</dc:date>
    </item>
  </channel>
</rss>

