topic Re: Set value on a field when the user open a document without using the "open document" trigger in QlikView

Set value on a field when the user open a document without using the "open document" trigger

Mon, 27 Jun 2016 22:39:55 GMT

Hi!

I would like to set a value on a field when the user open the document. I know that I can use the "open document" trigger in order to add the action "select on field" but the problem is that it does not work on server (access point). It works fine on desktop but not on server (access point). Please, do you know another way to achieve that? Have you ever had a similar situation? How did you solve it?

Thank you!

Linda

Re: Set value on a field when the user open a document without using the "open document" trigger

migueldelval — Tue, 28 Jun 2016 06:31:00 GMT

Hi Linda,

Maybe you can add a initial Sheet, and use "trigger" when you active the sheet. I use a landing page in all my documents to make this kind of actions.

Regards

Miguel del Valle

Re: Set value on a field when the user open a document without using the "open document" trigger

jyothish8807 — Tue, 28 Jun 2016 06:45:21 GMT

Hi Linda,

Try using the plugin version at access point and see if the triggers work or not ?

Regards

Re: Set value on a field when the user open a document without using the "open document" trigger

Anonymous — Tue, 28 Jun 2016 06:49:30 GMT

the Ajax client does not support this event. I think Miguel's suggestion is quite good. What are you trying to achieve?

Re: Set value on a field when the user open a document without using the "open document" trigger

Tue, 28 Jun 2016 14:49:08 GMT

Thanks for your answer Miguel... I do have an initial sheet, but the problem that I have with the "trigger" on activate sheet, is that it works only when I click on the sheet tab directly, It does not work when I open the document.

How do you do that? perhaps I am doing something wrong... do you have an example please?

I configured it like this:

Linda

Re: Set value on a field when the user open a document without using the "open document" trigger

Tue, 28 Jun 2016 14:53:58 GMT

Thanks for your answer KC. Which is the plugin version? and what does it do? (sorry but I am new in qlikview).

Linda

Re: Set value on a field when the user open a document without using the "open document" trigger

Tue, 28 Jun 2016 14:56:16 GMT

Hi Damian,

I need to set a date by default when the user open de document (exactly "yesterday") on my date fields.

Linda.

Re: Set value on a field when the user open a document without using the "open document" trigger

migueldelval — Tue, 28 Jun 2016 15:49:44 GMT

Hi Linda,

Try, please:

A) Accent in "día". Check that it´s the same value. It´s case sensitive.

B) Use a trigger to open the landing page when you open a document.

C) Make a buttom to navegate into the document. In "Acciones" first Layout/Activate sheet, and after this seection/select in Field.

Regards

Miguel del Valle

Re: Set value on a field when the user open a document without using the "open document" trigger

Wed, 29 Jun 2016 06:35:32 GMT

if there are "must select field", you can make can triger in it! Hope it helps!

Re: Set value on a field when the user open a document without using the "open document" trigger

jyothish8807 — Wed, 29 Jun 2016 08:50:26 GMT

Hi Linda,

In order yo use plugin version, you need to install QlikView plugins in your local system.You will get the link to download at top of your Access Point. "Download Internet Explorer Plugin".

From your access point if you click on + sign in front of the dashboard, then you will get option to open it in "Internet Explorer Plugin".

Regards

Re: Set value on a field when the user open a document without using the "open document" trigger

Anonymous — Wed, 29 Jun 2016 08:57:57 GMT

I noticed with QV V9 (couple of years ago) that sheet Trigger doesnot fire when you open the document with your destination sheet

So we defined a new sheet, where nothing else than a Trigger was defined to goto the wanted sheet

so the Trigger of the Destination sheet could fire

I donot know if that behaviour is the same in QV 11.20 or QV12

example: you want to open your app with sheet0 and define a Trigger on sheet0 to fire an action

Workaround: you define a new sheetA and define a Trigger goto sheet0
you define a document Trigger to goto sheetA

the enduser will not see that sheetA first will be displayed