Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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