Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mwscott1
Creator
Creator

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
jonathandienst
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.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
pgdavis2
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