topic Re: Excel as hyperlink in QlikView

Excel as hyperlink

Thu, 19 Feb 2015 10:21:52 GMT

i have a urgent requirment .i want to open excel from strt table as i am having the path of excel in my data

for eg my data is

name links

a a.xls

b b.xls

and a.xls is a hyperlink having the path of a.xls

now i want toi create a table like:

Name Links

a a.xls

b b.xls

and when i click to the a.xls in qlikview it should open that excel file which is stored as hyperlink in the data

kindly help

Re: Excel as hyperlink

Anonymous — Wed, 03 Aug 2016 23:19:35 GMT

I have similar requirement .. does any one have any inputs on this ?

Re: Excel as hyperlink

vishsaggi — Thu, 04 Aug 2016 00:32:21 GMT

Check here...

Launching files from QlikView

Used <URL> prefix.

Re: Excel as hyperlink

vishsaggi — Thu, 04 Aug 2016 00:34:01 GMT

Before you implement this I would say you guys to populate an excel sheet with Name, Path of those excel files you want to open and then pull this data into Qlikview. Then use the above link i sent to create a table and using <URL> create the hyperlinks accordingly. It worked at my end.

Thanks,
V.

Re: Excel as hyperlink

Anonymous — Thu, 04 Aug 2016 03:16:40 GMT

PFA . See whether it matches your requirement .