topic Re: Field Event /Variable Trigger not working to open URL in QlikView

Field Event /Variable Trigger not working to open URL

saumyashah90 — Wed, 11 Feb 2015 06:19:18 GMT

I have straight table.

Having Image Name and Image Location as columns.

Now when I click on any Image Name and event should trigger and open and URL.

Similarly on trying same with variables, I set variable on selection on Image Name.

and triggered an event in change of variable value to open the URL, but again its not opening

I have attached QVW and excel file with it

saumyashah90 — Wed, 11 Feb 2015 10:03:30 GMT

anyone??

jagan — Thu, 12 Feb 2015 02:07:42 GMT

Hi Saumya,

Try like this

Create a variable

vSelectedURL : =Only([Image Location])

Use below Macro in Document Properties -> Triggers-> Field Event Triggers-> On Select:

Sub Browse()

set v = ActiveDocument.GetVariable("vSelectedURL")

Set ie = CreateObject("Internetexplorer.Application")

ie.Visible = True

ie.Navigate v.GetContent.String

End Sub

Regards,

Jagan.

jagan — Thu, 12 Feb 2015 02:08:30 GMT

HI,

Please find attached file for solution.

Regards,

Jagan.

saumyashah90 — Thu, 12 Feb 2015 13:13:52 GMT

Hi Jagan,

This looks good

But on clicking clear all also it opens internet explorer.

jagan — Thu, 12 Feb 2015 15:34:49 GMT

Hi Saumya,

Try like this, Put one condition in macro like

If(GetSelectedCount(ImageName) = 1, MacroName)

Regards,

Jagan.