Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

HTTP link in local Qlikview OK, link on server not OK

Qlikview version 9.00 SR6.

According to examples, I used Settings->Document Properties->[Triggers][Field Event Triggers][OnSelect] and added "RunMacro" and "OpenURL".

sub OpenURL

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

        ActiveDocument.GetApplication.Launch ActiveDocument.Evaluate("Review"),""

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

    end if

end sub

Table Box.

This works when I click in the field "Review", containing one URL, in my local copy of the .qvw file on my machine.

When the .qvw file is moved to the server location it is the default behaviour of selection instead of following the link.

Please, can anyone explain if there are security options to set in order to allow macro execution in the server environment?

Chart Properties->[Expressions][Display Options] Representation Link

This works on the server.

8 Replies
Employee
Employee

Re: HTTP link in local Qlikview OK, link on server not OK

You need to make sure Macros are enabled on the server as well as unsafe macros. Not saying that the above will work (have not tested it). But launching an URL would be considered an unsafe macro.

Bill

zekazak
Contributor

Re: HTTP link in local Qlikview OK, link on server not OK

Hello,

Did you manage to get this stuff working on a server? As I've got exactly the same problem and struggling to get it working.

Best Regards,

~Sergejs

Not applicable

Re: HTTP link in local Qlikview OK, link on server not OK

Sorry, a work-around was necessary to get it working.

In the load script:

[delivery:]:

LOAD

// id and other fields

subfield(review_link,CHR(10)) AS Review

;

 

[ReviewLinks]:

LOAD

id
,
replace(Review,'/#/c','') AS URL_Text
,
IF(Review like '*http*','<url>' & purgechar(Review,CHR(13))) as URL_Link
Resident

delivery
;

Then a Chart/Straight table is required with,

Dimension id

Expressions/Display options/Representation Link

Expressions/Definition URL_Text & URL_Link

When a link is selected the question "Approve application for launch?" is shown in a pop-up.

Not applicable

Re: HTTP link in local Qlikview OK, link on server not OK

Sorry, a work-around was necessary to get it working.

In the load script:

[delivery:]:

LOAD

// id and other fields

subfield(review_link,CHR(10)) AS Review

;

 

[ReviewLinks]:

LOAD

id
,
replace(Review,'/#/c','') AS URL_Text
,
IF(Review like '*http*','<url>' & purgechar(Review,CHR(13))) as URL_Link
Resident

delivery
;

Then a Chart/Straight table is required with,

Dimension id

Expressions/Display options/Representation Link

Expressions/Definition URL_Text & URL_Link

When a link is selected the question "Approve application for launch?" is shown in a pop-up.

Not applicable

Re: HTTP link in local Qlikview OK, link on server not OK

Sorry, a work-around was necessary to get it working.

In the load script:

[delivery:]:

LOAD

// id and other fields

subfield(review_link,CHR(10)) AS Review

;

LOAD 

id
,
replace(Review,'/#/c','') AS URL_Text
,
IF(Review like '*http*','<url>' & purgechar(Review,CHR(13))) as URL_Link
Resident

delivery
;

Then a Chart/Straight table is required with,

Dimension id

Expressions/Display options/Representation Link

Expressions/Definition URL_Text & URL_Link

When a link is selected the question "Approve application for launch?" is shown in a pop-up.

[ReviewLinks]:

Not applicable

Re: HTTP link in local Qlikview OK, link on server not OK

Sorry, a work-around was necessary to get it working.

In the load script:

[delivery:]:

LOAD

// id and other fields

subfield(review_link,CHR(10)) AS Review

;

LOAD 

id
,
replace(Review,'/#/c','') AS URL_Text
,
IF(Review like '*http*','<url>' & purgechar(Review,CHR(13))) as URL_Link
Resident

delivery
;

Then a Chart/Straight table is required with,

Dimension id

Expressions/Display options/Representation Link

Expressions/Definition URL_Text & URL_Link

When a link is selected the question "Approve application for launch?" is shown in a pop-up.

[ReviewLinks]:

zekazak
Contributor

Re: HTTP link in local Qlikview OK, link on server not OK

Thanks for your reply. Unfortunately it still works just on desktop and from IE plugin, but doesn't work from Ajax.

Best Regards,

~Sergejs

Not applicable

Re: HTTP link in local Qlikview OK, link on server not OK

I forgot the IE plugin, I suppose the URI http://app/QvAJAXfc/... does not automatically mean that Ajax is used.

Check http://community.qlik.com/thread/71445 since I am not an expert in differences between Ajax and IE plugin and Explorer works for me (TM).

Community Browser