topic Re: Open a word or excel file in Qlikview Access point nd in QlikView

Open a word or excel file in Qlikview Access point nd

Mon, 21 Apr 2014 18:16:45 GMT

Hello Every one,

I need to add a button on a dashboard so that when some one clicks on it. It should open a word document.

So finally I created a button and in its properties-> Actions .. I gave the path of the excel file that I wanted to open if some who clicks the button and I achieved this.

But I need to open the same document in Access point when some user clicks the button. How may I achieve that. could some please help me on this

I tried giving static path of the server in the Properties-->Actions of the button...but it didn't help. Please check the example that I achieved.

Thanks in advance

Re: Open a word or excel file in Qlikview Access point nd

whiteline — Mon, 21 Apr 2014 18:29:18 GMT

Hi.

You can create a network share and open the file by network path.

Or use SharePoint server to host the files and open by url.

Re: Open a word or excel file in Qlikview Access point nd

Mon, 21 Apr 2014 18:38:17 GMT

white line

Thanks for the reply.

I tried giving network shared path and static path of the file located in the server, but that didn't help. Here weren't using any Source control tools like sharepoint /TFS . If there is any other alternate please help me.

If there any alternative , An example qvw would be appreciated.

Thanks in advance

Re: Open a word or excel file in Qlikview Access point nd

whiteline — Mon, 21 Apr 2014 18:54:59 GMT

For network shared path use Open URL action.

Re: Open a word or excel file in Qlikview Access point nd

Mon, 21 Apr 2014 19:29:29 GMT

white line

I just tried that didn't helped. Any other idea

I don't know Y but its opening the shared folder where this the excel file exist but its not opening the xls file

Re: Open a word or excel file in Qlikview Access point nd

Bill_Britt — Mon, 21 Apr 2014 19:30:36 GMT

Hi John,

You can do this but it will take a few more steps.

1. Create folder on server and name it Docs.

2. In IIS create a new Virtual Folder and point it to Docs.

3. In QVW at the URL to Http://servername/docs/documentname

Just tested it on my system and it worked.

Bill

Re: Open a word or excel file in Qlikview Access point nd

Mon, 21 Apr 2014 19:55:04 GMT

Bill

Thanks Very much Bill.

Re: Open a word or excel file in Qlikview Access point nd

andrefpc — Mon, 15 Sep 2014 13:27:40 GMT

Bill what if I'm not using IIS, is there another way to achieve this? Do I have to install ISS? Will it conflict with QlikView web server?

Thanks!

Re: Open a word or excel file in Qlikview Access point nd

Bill_Britt — Mon, 15 Sep 2014 13:46:32 GMT

Hi,

Yes, this can be done with QVWS. You have to add your location and the Context type. The Context type can be a little tricky. Now this will not allow the documents to show up in the Access Point, but you can open the document with a URL. If I had a test.docx in the test folder the URL would be http://servername/test/test/docx

Bill

Re: Open a word or excel file in Qlikview Access point nd

andrefpc — Mon, 15 Sep 2014 17:03:52 GMT

Thanks for your response Bill, I think I followed what you described in your last post, the .pdf extensions is set by default in the server (application/pdf), I created a new folder where I pasted the pdf that I want to open and created the button with the url which looks like this... http://QVWSIPAddress/Glossario/GlossarioQV.pdf but I always get the 404 page not found error, I checked folder and file permissions and everything seems fine.

Re: Open a word or excel file in Qlikview Access point nd

Tue, 03 Feb 2015 13:56:18 GMT

Andre

Did you find a solution?

Having a similar problem here.

Thanks,

Brian

Re: Open a word or excel file in Qlikview Access point nd

andrefpc — Thu, 26 Feb 2015 10:39:24 GMT

Yes Brian, I've found the solution with a BIG help of bbt.

I dont' know what's your QVS setup but I'll try to explain the steps I've followed.

-I've pasted the file I want to open in the "live directory" (the same as your QVW files);

-In QMC > System > Qlikview Web servers create a new root folder with the path to the "live directory"

-In my case I created a text box to open the pdf file, with the action set to "Open URL" and the URL field like this

='http://qvs_ip_address/name of folder created in step 2/name of the file.pdf'

Hope this helps.

Re: Open a word or excel file in Qlikview Access point nd

Mon, 21 Sep 2015 07:22:52 GMT

hi,

thanks alot

it is very useful

best regards

hamide