topic Dynamically change URL of a button in QlikView

Dynamically change URL of a button

Thu, 04 Feb 2010 00:15:52 GMT

In QlikView 9, I need to write a macro which take an existing button within a document and change the URL which the button launches based on selections within the sheet. I know how to find the selections and build the URL, but what I cannot determine is what properties to set on the button.


set btn = ActiveDoc.GetSheetObject("BU23")
set prop = btn.GetProperties
--- In here, I need to set the properties for the URL to launch when the button is clicked
btn.SetProperties prop

I've checked through the forums and have not found an example of this, and the API reference refers to a type if IArrayOfActionItems but that type is not defined in the API qvw.

Thanks!

Dynamically change URL of a button

disqr_rm — Thu, 04 Feb 2010 01:58:49 GMT

You are correct, that definition is missing in the API Guide.

A workaround I can suggest. Have your button call a sub where you can open IE with the manipulated URL. Something like this should work:


strLink= "http://www.yahoo.com"
Set objIExplorer = CreateObject("internetexplorer.application")
objIExplorer.visible = True
objIExplorer.navigate strLink
Set objIExplorer = Nothing

Dynamically change URL of a button

Thu, 04 Feb 2010 02:19:37 GMT

I should add that I need this to work when used from the QlikView server. Launching an application won't work, as it runs on the server.

Dynamically change URL of a button

disqr_rm — Thu, 04 Feb 2010 02:31:32 GMT

You sure this doesn't work on the server?

Can you try putting just someple line in sub and test it out another option, which works in "web" environment usually. Just call:

window.open http://www.google.com

Sorry, don;t have access to a server right now.

Dynamically change URL of a button

rwunderlich — Thu, 04 Feb 2010 04:32:21 GMT

Instead of messing with properties, define the button launch action as a variable and then manipulate the variable contents.

-Rob

Dynamically change URL of a button

Thu, 04 Feb 2010 14:43:18 GMT


Rob Wunderlich wrote:
Instead of messing with properties, define the button launch action as a variable and then manipulate the variable contents.

That's actually the first thing I thought of, but it doesn't seem to work. It's possible I'm doing something wrong.

Can you provide an example of setting the target of a launch action as a variable? I've gotten the variable set via the macro, but I cannot get the button to then launch the location specified by the variable.

-Kevin

Dynamically change URL of a button

Thu, 04 Feb 2010 15:27:09 GMT


Rakesh wrote:
You sure this doesn't work on the server?
Can you try putting just someple line in sub and test it out another option, which works in "web" environment usually. Just call:
window.open http://www.google.com
Sorry, don;t have access to a server right now. <div></div>

I believe window.open is for VB, not VB Script, but I will confirm that. I did this approach, which did not work on the server:

set app = ActiveDocument.Getapplication
 app.Launch baseURL & "?" & params, ""

-Kevin

Dynamically change URL of a button

rwunderlich — Thu, 04 Feb 2010 15:50:35 GMT


troj wrote:Can you provide an example of setting the target of a launch action as a variable? I've gotten the variable set via the macro, but I cannot get the button

Kevin,

Attached is an example of deriving the launch URL from selections without using a macro. Two methods are shown, build the URL in an Expression and building in a Variable. Hope this is what you were looking for.

-Rob

Dynamically change URL of a button

Thu, 04 Feb 2010 15:58:39 GMT

I've continued to play with this, in hopes of finding a solution. One thing of note is that I was originally trying this via the Ajax Client, which is something I'd still like to get working.

When I switch to the IE Plugin, I can use the following VB Script within a macro, and have it work. More than likely, this is because with IE, VB Script can run within the browser.

if (params = "") then
 msgbox "No selections"
 else
 dim app
 set app = ActiveDocument.Getapplication
 app.Launch baseURL & "?" & params, ""
 end if

I'd still like a method which works via Ajax, where the macro directly launches the page, or where I can change the launch URL for a button via a macro, or change a variable and have the button launch the contents of the variable.

-Kevin

Dynamically change URL of a button

Thu, 04 Feb 2010 16:01:52 GMT


Rob Wunderlich wrote:
Attached is an example of deriving the launch URL from selections without using a macro. Two methods are shown, build the URL in an Expression and building in a Variable. Hope this is what you were looking for. <div></div>

Thanks, Rob -- that showed me where I went wrong! I was trying

=$(variable)

instead of

=variable

as the URL.

It's the little things....

I'll give that a shot with the Ajax client, and see if it works.

-Kevin

Dynamically change URL of a button

Thu, 04 Feb 2010 16:16:31 GMT

Interesting - I'm finding behavioral differences between the IE Plugin and the Ajax client. What works in one doesn't seem to want to work in the other.

In the IE plugin, I can have the macro determine the URL and launch it via this code

if (params = "") then<pre> msgbox "No selections"
 else
 dim app
 set app = ActiveDocument.Getapplication
 app.Launch baseURL & "?" & params, ""
 end if

However that does not work in the Ajax client. For the Ajax client, I have to set the value into a variable, and have the button have a second action of "Open URL" with a target of

=URLvariable

.

Where it gets interesting is the method that works for the Ajax client doesn't work in the IE plugin, and vice-versa!

So, the client to be used affects the required solution.

-Kevin

Dynamically change URL of a button

disqr_rm — Thu, 04 Feb 2010 16:28:30 GMT

That's what I thought, and so asked you that you are sure if it doesn't work on the server. Regarding AJAX, I don't know much.

Glad that you see something positive.

Re: Dynamically change URL of a button

Wed, 30 Oct 2013 11:22:34 GMT

Hi Troj, Did you find a macro that works fine via Ajax?