topic Re: Launch linked document from AJAX client in QlikView

Launch linked document from AJAX client

colinh — Thu, 22 Jan 2015 10:28:54 GMT

Hi all

I have created a chart with a link to a spreadsheet that is stored on a server using the expression type "Link". This works perfectly from my development machine, but does not work when I have published the document to the server and opened it in the Full Browser (AJAX) client.

My current syntax - =File&'<url>\\10.1.8.204\C$\QlikView\Spreadsheets\' & File - works from my desktop but not from the AJAX client. Changing the \ to / causes the browser to attempt to open the document in another browser tab. I've tried pointing to a shared folder as well, rather than the C$ drive. The field "File" in this case contains the value "spreadsheet.xlsx".

Is there specific syntax I can use in the link to cause the document to be opened in the right program (in this case Excel)?

Thanks

Re: Launch linked document from AJAX client

datanibbler — Thu, 22 Jan 2015 11:03:05 GMT

Hi Colin,

a question beforehand: How - and why - have you created a chart with the link as an expression? Would you mind uploading a screenshot, I cannot imagine what that looks like.

What is the advantage of that over just using a button?

Using a trigger (put on a button), the settings allow you to specify which program to start - but usually that isn't even necessary as Excel files should be associated with MS_Excel, so specifying that file should be enough to cause it to be opened in Excel.

Best regards,

DataNibbler

Re: Launch linked document from AJAX client

colinh — Thu, 22 Jan 2015 11:28:53 GMT

This is test data, but it shows you what the chart looks like:

I wanted it in this format, rather than using a button, so that the user can launch the relevant document straight from the list of documents, rather than having to select a document and click a button.

The Link expression is the expression from my original post. The document details are loaded in the load script using:

WorkingsSpreadsheets:

LOAD FileBaseName() as Document,

FileBaseName()&'.'&FileExtension() as File,

FileTime() as [Last Updated],

'1' as FakeContent // file details do not load without some content

FROM

[$(vDataPath)\Spreadsheets\*.*]

(ooxml, embedded labels, table is Sheet1);

Re: Launch linked document from AJAX client

Thu, 22 Jan 2015 12:09:35 GMT

Do you get an error when you try to open or what happens? Could be permissions to access the files causing some problem

Re: Launch linked document from AJAX client

colinh — Mon, 26 Jan 2015 06:42:04 GMT

Joe, I'm not getting an error message, just a webpage not found message. The link is trying to open the file in another browser tab, rather than in Excel.

I'm testing with a button to see if it is a permissions issue, if the button works but the link doesn't then it would be the link syntax. If the button doesn't work then it could be a permissions issue.

Thanks