Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel as hyperlink

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

4 Replies
Anonymous
Not applicable
Author

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

vishsaggi
Champion III

Check here...

Launching files from QlikView

Used <URL> prefix.

vishsaggi
Champion III

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.

Anonymous
Not applicable
Author

PFA . See whether it matches your requirement .