topic Hyperlink Question with QlikView in QlikView

Hyperlink Question with QlikView

Dayna — Wed, 30 Jun 2010 13:49:43 GMT

Dear all,

I have a question, there is a rather large excel file that I am trying to put into QlikView, and contained within are links to other documents on the network - i.e. 001 points to a location on a users Shared Drive.

Is there any way for QlikView to use this data, and provide the hyperlink to the document from the QV App?

Many thanks for your help!

Kind Regards,
Dayna

Hyperlink Question with QlikView

fernandotoledo — Wed, 30 Jun 2010 14:00:48 GMT

You should create a field in excel with this link. Then create a button or event (like a selection in a field) with an action that opens that link.

That´s an idea....

Fernando

Hyperlink Question with QlikView

Anonymous — Wed, 30 Jun 2010 14:40:28 GMT

Dayna,
Take a look at the chart properties -> expressions -> representation. there is "Link" there. See online help about how to use it.

Hyperlink Question with QlikView

Dayna — Thu, 01 Jul 2010 09:58:09 GMT

Hello all,

I tried the option within the expression tab, but it didn't appear to work - would you mind uploading an example of a link to a document?

Many thanks!

Kind Regards,
Dayna

Hyperlink Question with QlikView

Or — Thu, 01 Jul 2010 10:12:48 GMT

The syntax required by QV for links is

DisplayText<url>DesiredLink

For example:

Google<url>www.google.com

In your case, your expression will probably look something like this:

=ColumnWithDocumentName & '<url>' & ColumnWithDocumentLink

Hope this helps.

Hyperlink Question with QlikView

Dayna — Thu, 01 Jul 2010 10:18:12 GMT

Ah, I understand... My issue tho, is they haven't wrote out the link address, just included it within the name.. without them typing the link, i guess this won't work?

Hyperlink Question with QlikView

Or — Thu, 01 Jul 2010 11:03:41 GMT

If the link is typed into a longer field - e.g. a classic HTML <A HREF=> tag - you can break it down with string functions to extract the link.. could you post an example text from one of these link fields?

Hyperlink Question with QlikView

Dayna — Thu, 01 Jul 2010 12:17:23 GMT

Hello,

Please find attached 🙂

Kind Regards,
Dayna

Hyperlink Question with QlikView

Or — Thu, 01 Jul 2010 13:02:36 GMT

Assuming your links are consistent with the ones you supplied, you can use (as an expression formatted as link):

[DEV REF] & '<url>../AppData/Local/Stability%20Sheets/Stability%20Sheet%20Page%20' & [PAGE NO] & '.xls'

However, I was not able to get QV to load the actual hyperlink, unfortunately, so if the links are not consistent within a path, this will not work (perhaps someone else knows a way to load the actual links)

Hyperlink Question with QlikView

Dayna — Wed, 07 Jul 2010 14:29:46 GMT

That''s great, many thanks everyone for your help!