Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

API Script

We are using GIS -API and I have the below hyperlink in the Popup content

           <a href="http://www.abc.com-us/insights/research-the-market#?Keyword='& [(if(Cluster=null(),Market,Cluster))]&'&FilterTypes=Research" class="btn btn-info btn-xs" target="_blank">View abc </a>

Here if I give as below it works fine

   

<a href="http://www.abc.com-us/insights/research-the-market#?Keyword='& [Cluster]&'&FilterTypes=Research" class="btn btn-info btn-xs" target="_blank">View abc </a>


Cluster and Market are 2 fields in the data file and when I use just Cluster my hyperlink shows as below.

Ex:Here Cluster is Washington,DC.


http://www.abc.com/en-us/insights/research-the-market#?Keyword=Washington, DC&FilterTypes=Research


and when I use [(if(Cluster=null(),Market,Cluster))]


it is not doing the filtering logic and hence the hyperlink looks as below


http://www.abc.com/en-us/insights/research-the-market#?Keyword=&FilterTypes=Research


When the cluster is blank I want this hyperlink to pick the Value from Market column.How can I achieve that ?


Thanks much