topic Re: Open an external document in QlikView

Open an external document

Mon, 14 Oct 2013 07:26:12 GMT

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.

Re: Open an external document

vivientexier — Mon, 14 Oct 2013 07:56:31 GMT

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

Re: Open an external document

Gysbert_Wassenaar — Mon, 14 Oct 2013 07:57:19 GMT

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.

Re: Open an external document

Mon, 14 Oct 2013 10:27:39 GMT

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

Thanks! Regard

Re: Open an external document

vivientexier — Mon, 14 Oct 2013 10:45:42 GMT

What is the difference ?

Re: Open an external document

Mon, 14 Oct 2013 11:04:24 GMT

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

Re: Open an external document

Mon, 14 Oct 2013 11:16:37 GMT

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.

Re: Open an external document

Anonymous — Mon, 14 Oct 2013 11:52:45 GMT

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

Re: Open an external document

Mon, 14 Oct 2013 12:07:01 GMT

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.

Re: Open an external document

Anonymous — Mon, 14 Oct 2013 12:35:01 GMT

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

Re: Open an external document

Peter_Cammaert — Mon, 14 Oct 2013 12:49:39 GMT

Another nice trick is to use the Expression Display Type "Link". Because QlikView is rather careful about relinquishing control, you'll have to confirm the launch of the external application (like Word, Acrobat Reader and such).

See example below, check little piece of script code, and especially the expression format and display type in the Chart object.

Good luck,

Peter