Thursday 20 June 2013

Qlikview Actions - Launch another application (eg. Open Excel and file)

Neat little trick in Qlikview.

A Qlikview report reads from an Excel file to get some data.  User asked if could add a link to open that Excel file (so they can check source / update).

Created a Button and added External Action -> Launch.

Application = "Excel".
FileName = "\\.....xlsx".

Was pleasantly surprised that simply putting in Excel was sufficient to identify the application.  Thought it may have needed a full path to an .exe which may have been problematic as Excel.exe might not be in the same place on all users computer.

No comments:

Post a Comment