Launch linked document from AJAX client

[colinh]

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

[datanibbler]

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

[colinh]

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);

[#4]

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

[colinh]

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