Load an Excel column with hyperlinks into QlikView?

[richardouellett]

Is it possible to load an Excel  column with hyperlinks into QlikView?  If yes can you direct me to an example or resource?

[settu_periasamy · Accepted solution]

I think we can't fetch the hyperlink details from the excel cell (as i know)

may be the workaround, you can simply put the below macro in your excel and get the hyperlink value in separate column..

Sub ExtractHL()

Dim HL As Hyperlink

For Each HL In ActiveSheet.Hyperlinks

HL.Range.Offset(0, 1).Value = HL.Address

Next

End Sub

source : How to extract a URL from a hyperlink on Excel

Load your fields..

LOAD dim,

    hyperlink

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

Create a chart

dim as your dimension

=dim & '<url>'&hyperlink  as your expression, representation should be Link..

-> You can hide your dim field if you don't want..

[trdandamudi]

As far as my knowledge it is not possible.

[richardouellett]

Very helpful, thank you very much for the example!