Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to load an Excel column with hyperlinks into QlikView? If yes can you direct me to an example or resource?
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..
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..
As far as my knowledge it is not possible.
Very helpful, thank you very much for the example!