Using triggers in Document properties

[rahulhv1]

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.

[juleshartley]

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

[maxgro]

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?

[juleshartley]

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...

[jonathandienst]

Hi

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

[juleshartley]

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...