topic Re: Load an Excel column with hyperlinks into QlikView? in QlikView

Load an Excel column with hyperlinks into QlikView?

richardouellett — Wed, 04 May 2016 11:59:38 GMT

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 — Wed, 04 May 2016 17:53:33 GMT

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 — Wed, 04 May 2016 17:57:54 GMT

As far as my knowledge it is not possible.

richardouellett — Wed, 04 May 2016 23:25:32 GMT

Very helpful, thank you very much for the example!