Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 

Hyperlinks from Excel spreadsheet

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.

2 Replies
Partner - Champion III
Partner - Champion III

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.



Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Partner - Creator
Partner - Creator

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