Re: Open an external document - Qlik Community

Report Inappropriate Content · ‎2013-10-14

Good morning friends,

I have been looking for information about how to open (or download) external documents (like pdfs, words or something like that) from QlikView, but I have not found the solution.

Does anybody know if this this is possible?

Thanks a lot.

Regards.

vivientexier · ‎2013-10-14

Hello,

Use a button or a text object and add an action "External" then "Open URL". All you need to do is to add your document URL. That's all

Gysbert_Wassenaar · ‎2013-10-14

Try using a button or text object with an Open URL action assigned to it. The url should be the path/url to the external file you want to open.

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2013-10-14

Well, it is not exactly what I want to do, but right now, it is ok!!

Thanks! Regard

vivientexier · ‎2013-10-14

What is the difference ?

Report Inappropriate Content · ‎2013-10-14

Well what I exactly want to do is open it on QlikView, not download it, but I think your solution will be ok!

Report Inappropriate Content · ‎2013-10-14

Create an excel file with two columns. Let the information in this file look like below

Keys,Files
A1,C:\Sajeevan\Doc1.docx
A2,C:\Sajeevan\Doc2.docx
A3,C:\Sajeevan\Doc3.docx
A4,C:\Sajeevan\Doc4.docx
A5,C:\Sajeevan\Doc5.docx
A6,C:\Sajeevan\Doc6.docx

Then load this using Info load like the below

Data3a:
info LOAD Keys,
Files
FROM
C:\Sajeevan\Book1.xlsx
(ooxml, embedded labels, table is Sheet1);

Use the Keys in a list box. You will get "i" on the top of the list box. Click this which will open the external document.

Anonymous · ‎2013-10-14

Hi Sajeevan,

I tried your method, it's only gives the pop up for the path. It's doesn't open the link. I hope info link would only show the info rather opening the link. please correct me if wrong.

Best,

Skumar

Report Inappropriate Content · ‎2013-10-14

Hi Kumar,

I am using QlikView version V11.0.11440.0 SR2 and the document is automatically opened when I clicked "i" on top of the list box. Are you using the same version or a different one?

Find below how the list box looks like.

Anonymous · ‎2013-10-14

Thanks for the reply.

Yes, even I am using same version. I got it working but did some trick. Now instead of excel file I have put same information in inline table with info load and it's working fine.

Thanks