Hyperlink Question with QlikView

[Dayna]

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

[fernandotoledo]

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

[Anonymous]

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

[Dayna]

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

[Or]

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.

[Dayna]

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?

[Or]

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?

[Dayna]

Hello,

Please find attached 🙂

Kind Regards,
Dayna

[Or · Accepted solution]

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)

[Dayna]

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