topic Using triggers in Document properties in QlikView

Using triggers in Document properties

rahulhv1 — Mon, 13 Oct 2014 05:20:07 GMT

Can is use trigger in Document properties ->OnOpen->Dynamic Update-> and write below code under it

Load User,

Division,

Country,

Plant

from d:\trialqvd.qvd (qvd) where user = osuser();

I have written above code in my document's main tab , also I have used trigger Document Properties->OnOpen->Reload.

It is working fine if I open the document in qlikview, but when I open the document in internet browser (IE or Chrome) through my Aceess point, it is not working . Would anyone pls. help me.

Re: Using triggers in Document properties

juleshartley — Tue, 21 Oct 2014 14:46:58 GMT

I am having this same problem - did you ever find a cause? I am a member of 'QlikView Administrators' and I've got 'Enable dynamic data update' checked on the server and document

Re: Using triggers in Document properties

maxgro — Tue, 21 Oct 2014 17:46:19 GMT

onopen trigger isn't supported in Ajax (= on server when you use Chrome, Firefox, etc.... or IE without plugin)

Re: AJAX with OnOpen macro

maybe you need section access to filter data by user?

Re: Using triggers in Document properties

juleshartley — Wed, 22 Oct 2014 08:01:40 GMT

Thanks, but I've tried it with IE plugin too. I am not trying to restrict the data, but update a certain field with a value... I've also tried attaching the action to a button but this doesn't work either...

Re: Using triggers in Document properties

jonathandienst — Wed, 22 Oct 2014 08:46:42 GMT

When you open from the portal (ajax or plug in) you always get user level access, regardless of the section access user/admin setting. If you want to reload from a document opened from the portal, you need to make sure that user access has permission to do the reloads. This is controlled from the Document Properties | Security tab.

I would NOT recommend that you do it this way. A better way, in my opinion is to use an EDX trigger to perform the reload. Search the community for ways to trigger EDX from the opened model.

HTH

Jonathan

Re: Using triggers in Document properties

juleshartley — Wed, 22 Oct 2014 08:57:39 GMT

Hi Jonathan,

thanks for that, but I'm not trying to trigger a reload. I'm simply trying to do a local dynamic data update... the data does not need to be pushed back to any server etc. It is purely local. The reason it can't be put into a variable is that it needs to be selectable...