topic Re: Hyperlinking a Dimension Value to a web URL in QlikView

Hyperlinking a Dimension Value to a web URL

Anonymous — Tue, 08 Dec 2015 00:51:17 GMT

I have an expressionless straight with a number of dimensions. I want to be able to click on dimension value and hyperlink this to a URL where it inserts the value of the dimension in the URL field. I have seen an example which uses a textbox for hyperlinking but not based on a dimension (Field) value.

Is this achievable in QV and if so how?

Regards.

Chris

Re: Hyperlinking a Dimension Value to a web URL

tamilarasu — Tue, 08 Dec 2015 01:37:10 GMT

Hi Christopher,

Check the attachment.

Re: Hyperlinking a Dimension Value to a web URL

Anonymous — Tue, 08 Dec 2015 02:13:17 GMT

Many thanks Tamil, that should do however, when i get the following on clicking the link:

When a qlik Yes, the URL does not launch. I am not sure why.

Re: Hyperlinking a Dimension Value to a web URL

sunny_talwar — Tue, 08 Dec 2015 02:20:43 GMT

Google is having not trouble in getting launched:

Modified Tamil's script to add google's link:

Data:

LOAD * INLINE [

Brand, Link, Sales

BMW, https://www.google.com/?gws_rd=ssl, 10

Audi, https://www.google.com/?gws_rd=ssl, 20

];

Re: Hyperlinking a Dimension Value to a web URL

sunny_talwar — Tue, 08 Dec 2015 02:24:33 GMT

and this seems to be working for me as well:

Data:

LOAD * INLINE [

Brand, Link, Sales

BMW, http://worldwide.espacenet.com/, 10

Audi, http://worldwide.espacenet.com/, 20

];

Re: Hyperlinking a Dimension Value to a web URL

Anonymous — Tue, 08 Dec 2015 02:34:02 GMT

Many thanks Sunny, but my link is not Google, it is:

http://worldwide.espacenet.com/searchResults?ST=singleline&locale=en_EP&submitted=true&DB=worldwide.espacenet.com&query= & PatentNumber

Where the PatentNumber is a field in my application and it searches the url for this PatentNumber

Re: Hyperlinking a Dimension Value to a web URL

tamilarasu — Tue, 08 Dec 2015 02:37:51 GMT

@Sunny: Thanks

Sorry Christopher. I forgot to update the load script (Links). Check the updated attachment.

Re: Hyperlinking a Dimension Value to a web URL

Anonymous — Tue, 08 Dec 2015 03:01:34 GMT

Thanks Sunny, it was a machine problem. I am running the application of MacBook with Parallels. When i transferred the app to a windows machine, the link opened in internet explorer.

I do not why the hyperlink is not working in parallels desktop.