Discussion Board for collaboration on QlikView Management.
Qlikview version 9.00 SR6.
According to examples, I used Settings->Document Properties->[Triggers][Field Event Triggers][OnSelect] and added "RunMacro" and "OpenURL".
if ActiveDocument.Fields("Review").getSelectedValues.Count = 1 then
ActiveDocument.Back 'Go back so we don't do the selection
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.
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.
Sorry, a work-around was necessary to get it working.
In the load script:
// id and other fields
subfield(review_link,CHR(10)) AS Review
id,replace(Review,'/#/c','') AS URL_Text,IF(Review like '*http*','<url>' & purgechar(Review,CHR(13))) as URL_LinkResident
Then a Chart/Straight table is required with,
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.
Thanks for your reply. Unfortunately it still works just on desktop and from IE plugin, but doesn't work from Ajax.
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).