topic Can't get Document Trigger to work. in QlikView

Can't get Document Trigger to work.

Thu, 01 Mar 2012 15:30:37 GMT

I know it's me... it always is!

I have a variable that I have created to give me the maximum year in which there has been data entered. (There is a similar fomrula for max week in the selected year also.)

In my example, I am analysing weekly production, and I define the variable MaxYear as:

Max (TOTAL If(IsNull([Litres Produced]),Null(),[Year]))

I am trying to use this as a Document Trigger so that the year will be automatically selected on opening te document.

This then (I hope) allows Only(Year) to work without the user being required to select a period.

So I have selected the "Triggers" tab in Document Properties, there selected the Document Event Trigger "OnOpen", chosen the Action "Select in Field", selected the field "Year" (no quotes) and entered the formula above as the Search String.

I expected this would do what I wanted, but it appears to do nothing at all.

As usual... help please!

Dave

Can't get Document Trigger to work.

CELAMBARASAN — Fri, 02 Mar 2012 04:47:58 GMT

Hi,

Have you tried with = sign before your expression.

=Max (TOTAL If(IsNull([Litres Produced]),Null(),[Year]))

=Max(Year)

Hope it helps

Celambarasan

Can't get Document Trigger to work.

jagan — Fri, 02 Mar 2012 05:44:34 GMT

Hi,

Try this

=Max(YearFieldName)

This will always select the Latest year based on the selection.

If you want to get the max ever irrespective of selections then use

=Max(ALL YearFieldName)

Hope this helps you.

Regards,

Jagan.

Can't get Document Trigger to work.

Fri, 02 Mar 2012 09:54:47 GMT

Thanks Celambarasan,

It was as simple as "=" before the expression.

(Not needed before the field name.)

Muchas gracias!

Can't get Document Trigger to work.

Fri, 02 Mar 2012 09:56:12 GMT

Thanks Jagan,

I appreciate your time and input.