topic Hyperlink in a table in QlikView

Hyperlink in a table

Tue, 08 Sep 2009 05:53:29 GMT

Hi,

I'm new to Qlikview and I was trying to add a dynamic hyper link to a table row, ie..."my.server.com&parm1"= & col1.value, is this possible to do in QlikView Tables?

Thanks,

Hyperlink in a table

Tue, 08 Sep 2009 07:01:59 GMT

In QlikView 9 there is a new feature for building hyperlinks.

In the diagramms option you can set the "representation" to hyperlink for any formula.

Hope this helps ...

Best regards

Stefan

Hyperlink in a table

Tue, 08 Sep 2009 23:19:26 GMT

Thanks for the reply Stefan!

I was able to get the url to show correctly, however I was not able to make it active? Do I have to do something to get the link to be active? I'm using the Qlikview Personal Edition, could that be the issue?

Thanks.

Hyperlink in a table

Wed, 09 Sep 2009 00:55:45 GMT

Hi,

are you using QlikView 9?

This is a new feature in QV 9 ...

Best regards

Stefan

Hyperlink in a table

Wed, 09 Sep 2009 01:20:47 GMT

Yes I'm using 9.0, do I have to use the function Info?

Hyperlink in a table

Wed, 09 Sep 2009 01:32:14 GMT

Hyperlink in a table

Wed, 09 Sep 2009 02:13:50 GMT

Hi,

please have a look at the attached example.

Best regards
Stefan

P.S.: Note: the syntax for the formula is as follows (copied from reference manual):

=Name & '<url>' & Link

=Name & '<url>www.qlik.com'

Hyperlink in a table

Wed, 09 Sep 2009 02:51:14 GMT

Perfect, it worked!

Thanks Again.

Hyperlink in a table

Wed, 24 Feb 2010 22:31:16 GMT

Hi Stephan,

Can I ask you a question?

Can I have hyperlinks in a table box? In your example you have a char that has hyperlinks.

I have a table box with many fields, one of the field is NAME, I want to make NAME column as a hyperlink with URL = http://servername.com/givedetails.jsp?parmname=<NAME>

How can I achieve this?

Neaz

Hyperlink in a table

Sun, 18 Apr 2010 13:46:21 GMT

Hello Stefan,

May you please share the code snippets? I was not able to open the "demo example"?

Regards,

Krishna Kumar

Hyperlink in a table

Wed, 08 Sep 2010 13:29:46 GMT

All you need to do is follow the formula Stefan wrote above in an expression box and make the representation a link. See the image attached below:

Search is the title to be displayed that will be click-able... http://www.bing.com is the URL that will be launched... Note that <url> must be between the display name and the URL and it is a string (closed in single quotes).

Hyperlink in a table

Tue, 24 Jan 2012 23:23:48 GMT

I have read this and experimented with it however i am still not able to get my hyperlinks to work in a table box. I have them working in a Pivot table fine but they will not work in a table box because i cannot set the presentation to Link.

I cannot see some of the pictures in this discussion which may help me but they are not available any longer.

Any help on this?

Re: Hyperlink in a table

Mon, 23 Jul 2012 15:11:37 GMT

Hello,

I'm quite aware of how the Link feature works. However, I have run into roadblock with this feature. Let's say, that my link is http://google.com<88>

My expression would look somethin like this:

'Google'&'<url>http://google.com<88>'

The link feature seems to have a limitation with links containing <> signs. If i remove <88>, link feature works.

Is this a limiation ? Do we have a workaround with this scenario.

Thanks for your time.

James

Re: Hyperlink in a table

mr_ramshini — Wed, 22 Jun 2016 07:28:02 GMT

your example is very helpful but how i can read on archive site?

i want show the price of dollar in a chart so that i don't update a table price

exactly the chart read on site directly