topic Hyperlinks from Excel spreadsheet in QlikView

Hyperlinks from Excel spreadsheet

mwscott1 — Fri, 08 May 2015 14:34:03 GMT

I have an Excel spreadsheet with multiple columns. One of the columns (Name) contains a hyperlink. How do I get this to show as a hyperlink in QlikView. All of the hyperlinks are different and point to different sites. I have included a very simple example of my excel file.

Re: Hyperlinks from Excel spreadsheet

jonathandienst — Fri, 08 May 2015 14:41:11 GMT

The problem is how to get the URLS. The LOAD returns only the visible text of the hyperlink.

If you can provide a way to fetch the URL, then you can show them in hyperlinks in qvw, as a text field with the syntax DisplayName & '<url>' & URL

(where DisplayName and URL the loaded fields)

Finally, select "Link" in the Representation in the Expressions tab.

HTH

Jonathan

Re: Hyperlinks from Excel spreadsheet

pgdavis2 — Thu, 09 Jul 2015 03:07:46 GMT

You can add this user defined function to your spreadsheet (in VBA)

In the cells you want to return the hyperlink address just use the function GetURL(cell)

Function GetURL(rng As Range) As String

On Error Resume Next

GetURL = rng.Hyperlinks(1).Address

End Function