topic Qlikview Report 'hook' to spawn external applications? in QlikView

Qlikview Report 'hook' to spawn external applications?

Sat, 05 Dec 2009 04:49:24 GMT

I was wondering if there was an external hook/macro that could be invoked from a Qlikview report (via a mouse right click or similar) that could launch an external application with the Qlikview cell parameters that had been right clicked being passed to it.

e.g. a Telephone number from a Qlikview report table being passed to an application that would run a call trace on that number.

Many Thanks

Sandy

Qlikview Report 'hook' to spawn external applications?

rwunderlich — Sat, 05 Dec 2009 05:57:17 GMT

Yes, this is possible. The details depend on which version -- 8 or 9 -- and how you want the UI to behave.

If you want to have the "activation link" as a cell in a table, V9 provides the "Link" representation for an expression. The Customer Portal Content section has a video titled "How to create a clickable URL in QLikview 9" that provides an example. Note that the url does not need to be a "url", it can be something like a program name -- "cmd.exe". The parameter values would be included in the link expression. For example
='Run Trace' & '<URL>calltrace.exe' & PhoneNumber

This "link in a cell" method can be simulated in V8 using a macro. If you need V8 I can provide an example.

Another approach is use a button with a Launch action. This method works the same in V9 or V8. Add an enable condition to the button that enables the button only when one PhoneNumber is possible.

-Rob

Qlikview Report 'hook' to spawn external applications?

Sat, 05 Dec 2009 06:01:08 GMT

Thanks Rob!

I have v9.0.

I'll give it a try.

Cheers

Sandy

Qlikview Report 'hook' to spawn external applications?

Tue, 08 Dec 2009 17:22:29 GMT

Hi Rob,

The button with launch application fits my needs best.

However, I am struggling to see how I can pass the application the 'phonenumber'.

In my case the 'phonenumber' field is called IMSI. The button is only enabled when one distinct IMSI is selected. When I try and pass the field IMSI only the text 'imsi' is passed as opposed the required field contents (e.g. 310650700000442).

Any ideas?

Many Thanks

Sandy

Qlikview Report 'hook' to spawn external applications?

rwunderlich — Wed, 09 Dec 2009 02:14:59 GMT

If your completed launch command was to look like:

myprog.exe -n=310650700000442

then your expression in the Launch button Application field would look like:

='myprog.exe -n=' & only(IMSI)

Does that help? Post your button expression if you have more questions.

-Rob

Qlikview Report 'hook' to spawn external applications?

Wed, 09 Dec 2009 02:33:22 GMT

Hi Rob,

I have used a macro button to make it more flexible - code below. However, the first line returns the error -

>>> Object required: 'ActiveDocument.Fields(...)'

Any ideas?

Cheers

Sandy

sub UTEL

utelimsi = ActiveDocument.Fields("IMSI").GetSelectedValues

set WshShell = CreateObject("WScript.Shell")

WshShell.Run "iexplore.exe http://10.0.1.98/cgi-bin/uqos/tcapsearch.pl??Action=Search&Category=TCAP&From_Date=2009.12.07&From_Time=05:00&To_Date=2009.12.07&To_Time=06:00&Field=imsi&Operator=&Value=&bind1=and&Sub=&bind2=and&Expression=((imsi="&utelimsi_txt&"))&Button=View",3,true

end sub

Qlikview Report 'hook' to spawn external applications?

rwunderlich — Wed, 09 Dec 2009 02:49:40 GMT

Sandy,

Seems to me that a button without macro is easier, but if you want to get the value in the macro try:

utelimsi = ActiveDocument.Evaluate("only(IMSI)")

-Rob

Qlikview Report 'hook' to spawn external applications?

Wed, 09 Dec 2009 03:33:40 GMT

Hi Rob,

I have tried both routes without success.

1. Launch Method.

Application: C:\Documents and Settings\sandy.orr\Start Menu\Programs\Internet Explorer.lnk

Parameters: only(IMSI)

This simply puts the text 'only(IMSI)' in the URL.

Sorry, I am using v8.0 not 9.0.

2. For the macro this populated the string with '-' and not with the actual IMSI field value.

Any other ideas/direction greatly received!

Cheers

Sandy

Qlikview Report 'hook' to spawn external applications?

rwunderlich — Wed, 09 Dec 2009 03:39:49 GMT

Can you post your qvw?

Qlikview Report 'hook' to spawn external applications?

Wed, 09 Dec 2009 16:47:56 GMT

Hi Rob,

I would be happy to post it but it is 765MB!

Cheers

Sandy

Qlikview Report 'hook' to spawn external applications?

Wed, 09 Dec 2009 19:51:27 GMT

Hi Rob,

thanks for all the help - it is now working for imsi.

The fact that I was using IMSI instead of imsi for a while delayed my troubleshooting - sorry!

Cheers

Sandy

Qlikview Report 'hook' to spawn external applications?

rwunderlich — Thu, 10 Dec 2009 00:57:04 GMT


sandyorr wrote:
I would be happy to post it but it is 765MB!

For future reference, see this wiki for tips on reducing sample size.

http://community.qlik.com/wikis/qlikview-wiki/preparing-examples-for-upload-reduction-and-data-scrambling.aspx

-Rob

Qlikview Report 'hook' to spawn external applications?

Fri, 29 Jan 2010 04:51:13 GMT

Hello Rob,

You mentioned :

"...This "link in a cell" method can be simulated in V8 using a macro. If you need V8 I can provide an example. ..."

Can you please provide an example in V8 using a marco?

Thanks

Tai

Qlikview Report 'hook' to spawn external applications?

rwunderlich — Sat, 30 Jan 2010 00:02:18 GMT


Tai wrote:
Can you please provide an example in V8 using a marco?

You can find a sample file in this thread:
http://community.qlik.com/forums/p/24656/94255.aspx

-Rob

Qlikview Report 'hook' to spawn external applications?

Thu, 10 Jun 2010 09:22:44 GMT

Hi Rob,

I have added a button and in the action calling micro to launch an external application. In the qlikView client, it is working fine but on the server it is not working. It does not give any error either. I am using QVServer 9.

Please help.

Qlikview Report 'hook' to spawn external applications?

rwunderlich — Tue, 06 Jul 2010 22:24:25 GMT


rajeev830 wrote:I have added a button and in the action calling micro to launch an external application. In the qlikView client, it is working fine but on the server it is not working. It does not give any error either. I am using QVServer 9.

There is an option in the QVS Security settings "Allow unsafe macro execution on server". You probably need to set this option on.

-Rob