topic Re: Launch Application with Parameters in QlikView

Launch Application with Parameters

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

We have a maintenance ticket system, which resides on the users local hdd's - it draws data from a SQL database.

What we would like to do is launch the application from a qlikview document and pass in the ticked number, in other words:

"C:\Maint\Maint.exe id:1234", (where 1234 is the ticket number from the data row.) when the number is clicked.

I've tried various things but nothing seems to work.

='c'&'<url>'&'C:\Maint\Maint.exe' launches the application as expected, I can't get it to pass a parameter though!

Thanks

Re: Launch Application with Parameters

rwunderlich — Tue, 30 Oct 2018 11:43:02 GMT

='c'&'<url>'&'C:\Maint\Maint.exe id:' & ticketNumber

Re: Launch Application with Parameters

Anonymous — Tue, 30 Oct 2018 11:53:06 GMT

Hi Rob,

Thanks for answering this, I think this was one of the combinations I tried, it returns a "Failed To Launch" message with the exact path of what can be typed into a command prompt to get it to run.

I'm now wondering if there's some kind of block on running an exe with a passed param?

Re: Launch Application with Parameters

rwunderlich — Tue, 30 Oct 2018 12:02:24 GMT

Test it with a button "Launch Action" using file exe name as the "Application" and the "id:xxxx" as the parameter.

If that works then build your url as quoted strings like:

="'c'&'<url>'&'C:\Maint\Maint.exe" "id:' & ticketNumber & '"'

or use the button as a workaround

-Rob

Re: Launch Application with Parameters

Anonymous — Tue, 30 Oct 2018 12:48:45 GMT

Hi,

Thank you, tried the button and it works a treat