topic Re: Trigger to set Group current field on open document in QlikView

Trigger to set Group current field on open document

Tue, 08 Mar 2011 17:25:34 GMT

Hi guys,

How do I create a trigger to set the current field of a group when opening the document?

Thanks,

Aldo.

Re: Trigger to set Group current field on open document

thomas_wang — Wed, 25 Jul 2018 10:03:58 GMT

Hi All,

I have the same question. Is there any ideas?

Thanks!

Re: Trigger to set Group current field on open document

BalaBhaskar_Qlik — Wed, 25 Jul 2018 11:09:27 GMT

May be this helps:

document trigger "onOpen" set Field with if-else

Re: Trigger to set Group current field on open document

BalaBhaskar_Qlik — Wed, 25 Jul 2018 11:14:54 GMT

Do like this:

Go to Settings -> Document Properties -> Triggers

Select the “OnOpen” trigger and press “Add Action”

Add the Select in Field Trigger (section Selection)

Ex: Field - year

Search String: = max(year)

Now, go to the list box properties and select "Always one selected value" in general tab of the list box properties.

One thing to note here is that if you go by Always one selected value, then you will never be able to select more than one year. (for example you can not select 2010 and 2011 both).

So, it all depends your requirement, but always one selected mode should be preferred over triggers.

Re: Trigger to set Group current field on open document

rakeshkumar1890 — Wed, 25 Jul 2018 12:23:31 GMT

Hi Liaks,

I think on document you have created group with two or more fields in which on that field you have applied some logic, In that case you can create variable for that field with logic and can apply Document trigger to OnOpen option.

Re: Trigger to set Group current field on open document

thomas_wang — Thu, 26 Jul 2018 00:55:17 GMT

Hi Bhaskar,

What I want to set is the activated field in the group, not a selection in the field.

You may know a function called GetCurrentField(). What I want now should be a “SetCurrentField()” function.

You may have misunderstood me, or I didn't understand you.

Thank you anyway.

Re: Trigger to set Group current field on open document

thomas_wang — Thu, 26 Jul 2018 01:01:18 GMT

Hi Kumar,

According to my personal understanding, what you offer is an alternative?

Is there any way to preserve the original built-in group mechanism and implement the original requirements?

Thanks!

Re: Trigger to set Group current field on open document

BalaBhaskar_Qlik — Thu, 26 Jul 2018 07:55:23 GMT

May be add that function, in Search string area of the Action.

Re: Trigger to set Group current field on open document

thomas_wang — Fri, 27 Jul 2018 03:10:18 GMT

A Group is not a Field and cannot be recognized in Select in Field Trigger.

Thanks.