topic Triggers in access point in QlikView

Triggers in access point

Mon, 15 Nov 2010 10:52:10 GMT

Hi,

I use triggers in my application to clear all values and also to set default values and it works good. But when I publish this to access point it dosent work. How can I solve this ? / regards mikael

Triggers in access point

pover — Mon, 15 Nov 2010 18:07:17 GMT

I assume the trigger you are using to clear all values and set default values is the OnPostReload trigger which I have not seen work properly when the reload is done on QlikView Server or Publisher. However, the OnOpen trigger should work when opening the document on AccessPoint so try the OnOpen trigger.

Regards.

Triggers in access point

Fri, 19 Nov 2010 22:41:33 GMT

You can create a vbscript file that is run as a scheduled task that will clear values on a specific file.

Mikael

Start by getting a handle on the qvw file

'Create an instance of QlikView

set Qv = CreateObject("QlikTech.QlikView")

Set activeDocument = Qv.OpenDocEx ("file.qvw",0,false) ' Open the document

if you want to reset a variable you can easily get a handle

set var = activeDocument.Variables("varName")

var.SetContent 0, true

Kal