topic Setting a variable value on launch of a hyperlink in QlikView

Setting a variable value on launch of a hyperlink

qliksus — Tue, 28 Jun 2011 11:26:15 GMT

hi all,

i am launching a URL from the straight table box now when i click the hyperlink i want the variable value to be changed i have to do some actions

on the click of the hyperlink for this .so how can i track the click in my hyperlink

Re: Setting a variable value on launch of a hyperlink

IAMDV — Tue, 28 Jun 2011 11:50:37 GMT

Hi,

Do you have many Fields in the table? If it is only one Field in the table then you can use this IsActivate property.

Sub CountTableSelections()

Set obj = ActiveDocument.GetSheetObject( "CH01" )

IF Obj.IsActive = True Then

ActiveDocument.Variables("vTest").SetContent 1 + ActiveDocument.Variables("vTest").GetContent.String,True

Else

End IF

End Sub

Good luck!

Cheers - DV

Setting a variable value on launch of a hyperlink

qliksus — Tue, 28 Jun 2011 12:04:39 GMT

i can click the table first and then click on the link so in this case even if i simply click the table the variable will be

set i dont want that to happen what i want is only when i click the hyperlink in the expression the variable should be

set .Also where should i call this macro

Re: Setting a variable value on launch of a hyperlink

IAMDV — Tue, 28 Jun 2011 12:43:41 GMT

I totally agree with you. This is not the best solution and we need the property of Display Options > URL to capture the clicks. I am looking at the API guide and I'll get back to you if I find something better than this one. You use the Field Event Triggers and you can use "OnSelect" event with relevant field selected.

Cheers - DV

Setting a variable value on launch of a hyperlink

qliksus — Wed, 29 Jun 2011 05:28:00 GMT

Guys any update

Setting a variable value on launch of a hyperlink

Wed, 29 Jun 2011 06:07:20 GMT

Just a thought, but if you have built the hyperlink based on the data in your view, i.e.

=[Name]&'<url>'&'http://www.google.com/search?q='&Name

Couldn't you parse the GetCurrentSelections() function to build the variable? Or GetFieldSelections()?

Setting a variable value on launch of a hyperlink

qliksus — Wed, 29 Jun 2011 06:34:40 GMT

hi leonard,

what i am doing is i am passing the value to the URL which is taken as a dimension i.e

https://10.0.2.3/empid=[EMP ID] where the EMPID is the dimension in my chart. also when i click the link the

dimension [EMP ID] will not be selected so Getfieldselection() cant be used

Setting a variable value on launch of a hyperlink

Wed, 29 Jun 2011 07:22:29 GMT

Have you tried any field event triggers? Ctrl+Alt+D then go to the triggers tab. Seems you should be able to set the variable and launch the URL based on what you click in the [EMP ID] field? Or at least fire off a macro to do the same?

(Sorry this is way above where I have gone before so not a lot of help...)

Setting a variable value on launch of a hyperlink

qliksus — Wed, 29 Jun 2011 07:30:40 GMT

yes you are right i can trigger something when some field is selected but in this case the field will not be selected

just the link will be clicked so i have track the click on the link and then set a variable on that event

Hope this explains correctly what i need

Re: Setting a variable value on launch of a hyperlink

Wed, 29 Jun 2011 07:34:50 GMT

Could you add a second trigger to launch the URL when the field is

selected and not make the field itself a hyperlink?

Re: Setting a variable value on launch of a hyperlink

Wed, 29 Jun 2011 07:57:04 GMT

Check out this post on field triggers, I think it will point you in the

right direction...

http://community.qlik.com/message/101446#101446

Re: Setting a variable value on launch of a hyperlink

kaushiknsolanki — Wed, 29 Jun 2011 07:58:19 GMT

Hi,

I dont know is this a possible solution or not, but you can try if you feel so.

Create a seperate field in your table which will have the URL as the value.

So you can place a trigger on select of the value from this field.

Regards,

Kaushik Solanki

Re: Setting a variable value on launch of a hyperlink

IAMDV — Wed, 29 Jun 2011 08:10:10 GMT

Hi Mate,

Like I had mentioned in my first post of using Field Selection Even Trigger. Here is the basic example... I had not incremented the vTest value but if this idea works then you increment the vTest variable everytime the user clicks on the Chart.

Cheers - DV

Re: Setting a variable value on launch of a hyperlink

IAMDV — Wed, 29 Jun 2011 08:16:35 GMT

Just adding to my previous post. You can also use the same logic to create the straight table and it works fine. I hope this helps!

Cheers - DV

Setting a variable value on launch of a hyperlink

qliksus — Wed, 29 Jun 2011 08:37:45 GMT

thanks for the reply kaushik even if i do that when i change the representation to hyperlink

then the field will not be selected even if i click . it will show me some approval message for the link we have created

in the script that's y i am asking to track the click on the hyperlink

Setting a variable value on launch of a hyperlink

qliksus — Wed, 29 Jun 2011 08:41:13 GMT

hi DV,

thanks for the reply but i dont want this to happen on the selection of some field in your solution when u select a

field some link will be launched and then the variable will be set If you take the same field in straight table

and change the representation to link then u cant select that field that's the problem .

Setting a variable value on launch of a hyperlink

qliksus — Wed, 29 Jun 2011 08:43:48 GMT

Hi short,

thanks for the reply ur link is quite helpful but cant solve my problem refer my previous post for that

Setting a variable value on launch of a hyperlink

qliksus — Wed, 29 Jun 2011 17:49:23 GMT

guys any update

Setting a variable value on launch of a hyperlink

Thu, 30 Jun 2011 05:42:28 GMT

Hi,

You can set a macro to change the variable on the event of "OnAnyselect" of the document properties as follows:

Settings - > Document Properties -> Macros (tab)

Under "Document Event Triggers" you set a macro to change the variable value on the event trigger of "OnAnySelect"

In the macro you should verify whether the active chart is the one you wanted (that have links to click) otherwise dont set the variable.

It must solve your problem.

Re: Setting a variable value on launch of a hyperlink

kaushiknsolanki — Thu, 30 Jun 2011 08:48:05 GMT

Hi,

I hope you want something like this.

Have a look at the attachment.

Regards,

Kaushik Solanki