topic Re: Embed external files into Qlikview in QlikView

Embed external files into Qlikview

Thu, 15 Mar 2012 08:39:40 GMT

Hi,

Is it possible to embed a pdf or Excel viewer into a QV dashboard?

I thought this would be possible by using the OCX controls but I don't get them to work.

Is anyone aware if it is possible to just display a pdf or excel file inside a Qlikview dashboard?

Thanks in advance!

Kind regards,

Jens

Embed external files into Qlikview

jagan — Thu, 15 Mar 2012 10:52:51 GMT

Hi,

If you are using Qlikview 11, then use the "web page viewer" object and view it in Web View mode.

Regards,

Jagan.

Embed external files into Qlikview

Thu, 15 Mar 2012 11:10:18 GMT

Hi Jagan,

Thanks for your answer. I am using Qlikview 11 but to be honest I have no idea how to add/create/use the "web page viewer" object.

Could you tell me how this works?

Thanks in advance!

Kind regards,

Jens

Re: Embed external files into Qlikview

jagan — Thu, 15 Mar 2012 11:43:38 GMT

Hi,

Check the attached screen shot,

First change the mode to Web mode by clicking the icon, highlighted in the screen shot. Then add the Web Page Viewer in Extension objects section.

Regards,

Jagan.

Re: Embed external files into Qlikview

Thu, 15 Mar 2012 11:55:17 GMT

Hi,

Thanks I can now indeed see the extensions tab but I don't have any extensions to select.

Do I have to download them somewhere?

Kind regards,
Jens

Re: Embed external files into Qlikview

jagan — Thu, 15 Mar 2012 12:07:36 GMT

Hi,

You need to install Extension objects, you can install it by using the path

Drive Name: Program Files -> Qlikview-> Examples -> Extension objects

and double click the "Extension Examples.qar" file.

Regards,

Jagan.

Embed external files into Qlikview

Thu, 15 Mar 2012 13:13:11 GMT

Hi Jagan,

This indeed offers me the possibility to view web pages but not to display PDF files.

Is there anyway to integrate a pdf viewer into this extension?

Kind regards,
Jens

Embed external files into Qlikview

jagan — Thu, 15 Mar 2012 13:53:00 GMT

Hi,

In place of URL give the Path of the Pdf file in your machine which you want to display.

Regards,

Jagan.

Embed external files into Qlikview

Thu, 15 Mar 2012 15:04:06 GMT

Hi Jagan,

I did this already but then Qlikview opens the document in PDF Reader (outside of my dashboard).

I want that I can view my file inside the frame.

I tried using online pdf conversions but this doesn't to do the trick.

Any ideas?

Kind regards,

Jens

Embed external files into Qlikview

Thu, 15 Mar 2012 16:08:12 GMT

Hi Jagan,

I have managed to view my pdf file in Qlikview!

As you suggested I added the web page viewer to my dashboard.

In the URL I added a link to the Google Docs viewer that displays a pdf.

http://docs.google.com/viewer?url=http%3A%2F%2Fwww.steunpuntmowverkeersveiligheid.be%2Fmodules%2Fpublications%2Fstore%2F157.pdf

The pdf cleanly loads into my web page viewer in Qlikview.

Thanks for your assistance!

Kind regards,

Jens

Re: Embed external files into Qlikview

jagan — Fri, 16 Mar 2012 04:50:59 GMT

Hi,

If this discussion helps in arriving the solution then close this discussion by Clicking the Correct/Helpful Answers whichever the post(or my reply) helps you.

Regards,

Jagan.

Embed external files into Qlikview

flipside — Fri, 01 Jun 2012 14:28:33 GMT

There is an alternative way of displaying certain files in AJAX using the WebViewer on the server and it is by placing the files directly into the QVAJAXZFC root folder (path set in QEMC>System>Setup>Qlikview Web Servers>{name of server}>Web, but not sure if this is recommended or not!!

I got .pdf, .xls and .htm files (.htm need their associated files folder) to display fine. I used a folder structure so just need to reference as folder/filename in the WebViewer.

Has anyone any recomendations against doing this?

flipside

Re: Embed external files into Qlikview

Thu, 04 Oct 2012 06:15:46 GMT

Hi Flipside

Can you expand on your method, where do you store the eg .xls file and how do you referer to it on web viewer?

thanks

Re: Embed external files into Qlikview

flipside — Tue, 09 Oct 2012 10:46:13 GMT

Hi samlavers,

I haven't deployed anything yet but I'm about to re-visit this for an upcoming project I have. I'm assuming you've read through this thread and are familiar with the WebViewer extension.

The path is set in the extension properties whilst in webview (I have a problem webviewing on desktop and server for different reasons, so can't confirm exactly where you enter details but remember it being quite simple - I have to set it whilst in normal view mode by going to Sheet Properties > Objects > {ObjectID} > Properties > Presentation to edit the Text in Chart !!).

In QEMC or QMC you can see the root path for QVAJAXZFC (see above) - and this is where you COULD put documents, however these are system files so I wouldn't place them there. Instead create a folder called DocStore or something and place documents in there. This would need a path in the format ='DocStore/file.pdf'.

I've no idea what QlikTech's view is on all this, but it seems fine to me for occasional stuff such as help files, but if your document needs to access many files, as in my project, it isn't the best place, you'll need to find a more suitable location and method to access them.

Since last testing, I've upgraded to QV11 and can't now view .xls files directly (although it can download them) - so will probably be converting them to .mht files which work well.

flipside

Re: Embed external files into Qlikview

Wed, 10 Oct 2012 04:47:10 GMT

Thanks flipside

I can get an xls to embed and work perfect through Qlikvew desktop although when I try to access it through the AccessPoint the file doesn't load. I thought there may have been a specific directory that needed to be used in order for the document to be retrived.

Re: Embed external files into Qlikview

Mon, 05 Nov 2012 10:07:48 GMT

I'm also trying to achieve this. I can get JPG to view properly. But PDF, XLS and DOC files open externally.

I had this working in QV9. But now on QV11, it does not work. Any further ideas.

I cannot use Jens idea(about Google Docs viewer) as the files are stored on the internal network.

Thanks in advance

Pieter