topic Re: Macro for opening URL in QlikView

Macro for opening URL

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

From last 4 days i'm searching for the macro code that should work like "Open URL" function in Actions. And also the macro should work in AJAX access point also.

Please let me know is it possible or not ?

Greatly appreciated for your response.

Regards,

Venkat.

Re: Macro for opening URL

Fri, 22 Nov 2013 08:26:51 GMT

Can't you use the action itself?

Because as far as I have experienced, macros either don't work or display some weird behaviour in AJAX.

So my suggestion would be refrain from using macros.

Re: Macro for opening URL

jagan — Fri, 22 Nov 2013 09:05:42 GMT

Hi,

No need of macro, you can just achieve this using text box and triggers. Please find attached file for solution.

Hope it helps you.

Regards,

Jagan.

Re: Macro for opening URL

Fri, 22 Nov 2013 09:31:29 GMT

Hi,

On selecting a field value in a listbox it should open the web URL and i don't want any extra step to do user for opening the URL(i.e; Not to have Button click).

"Open URL" action is not working for field "On Select" event trigger so that's why i had choossen for Macro code. And i got a macro which works fine in "IE Plugin" but not supports in "AJAX". So i was looking eagerly for the macro that should also work in AJAX.

sub OpenURL

if ActiveDocument.Fields("Link").getSelectedValues.Count = 1 then

ActiveDocument.GetApplication.Launch ActiveDocument.Evaluate("http:\\WWW.GOOGLE.COM"),""

ActiveDocument.Back 'Go back so we don't do the selection

end if

end sub

Thanks in advance.

Regards,

Venkat

Re: Macro for opening URL

Fri, 22 Nov 2013 09:55:21 GMT

Hi Venkat,

Achieving the same requirement using a list box is not possible.

Instead you can use the same field in a straight table expression and change the representation as Link (Example Attached).

Hope this will sort out your issue.

* Only if the field values are the web links.

Vinoth

Re: Macro for opening URL

Fri, 22 Nov 2013 10:23:16 GMT

Hi Jagan,

I needs to display all images in listbox bcoz should be visible like m*n rows, The look & feel should like be as below image. I think this type of view is not possible by Textbox.

If i click on any image cell then it should open its image link .

Greatly appreciated for your response on this.

Regards,

Venkat

Re: Macro for opening URL

Fri, 22 Nov 2013 10:25:25 GMT

Ok. So now the question is, on what event are you using the action"Run Macro"?

Reason being, AJAX does not support "OnChange" of variable , as far as "OnSelect" is concerned, it should work in AJAX.

Refer to this:http://community.qlik.com/message/336101 for macros which work with AJAX and which don't.

Another approach is as suggested by Vinoth Kumar Rajendran, you can make that straight table look like a list box.

Thsi is the only way which I can think about as of now.

Re: Macro for opening URL

Fri, 22 Nov 2013 10:43:55 GMT

Hi Shyamal,

I'm using the action "On Select" in field event trigger. And i seen the approach that what Vinoth Kumar Rajendran has provided, but i can't make the visibility like "M*N" matrix in straight table.

Is there any chance of working exactly with same requirement like macro which works in AJAX also ?

Thanks in advance.

Re: Macro for opening URL

jagan — Fri, 22 Nov 2013 13:23:28 GMT

Hi Venkat,

Can you attach sample file, so that it would be easier to provide the solution.

Regards,

Jagan.

Re: Re: Macro for opening URL

Fri, 22 Nov 2013 13:43:39 GMT

Please find the attached app.