Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.
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.
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]:
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]:
Thanks for your reply. Unfortunately it still works just on desktop and from IE plugin, but doesn't work from Ajax.
Best Regards,
~Sergejs
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).