topic Formula in trigger in QlikView https://community.qlik.com/t5/QlikView/Formula-in-trigger/m-p/395877#M147628 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I would like to make a trigger on the action "open"</P><P></P><P>I have a field called Fiscal Period that goes from 1-12, when the year is over. Now I have 1 and 2.</P><P></P><P>Then I would like to say that when the report is opened, then it should open with filter on MAX (Fiscal Period) = 2, but I can not get it to work. If I type in 2, then it works. </P><P></P><P>Any help here? I have tried the formula MAX, MAXstring, NUMmax..</P><P></P><P>Best regards</P><P></P><P>Bjarne</P></BODY></HTML> Fri, 02 Nov 2012 09:48:19 GMT 2012-11-02T09:48:19Z Formula in trigger https://community.qlik.com/t5/QlikView/Formula-in-trigger/m-p/395877#M147628 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I would like to make a trigger on the action "open"</P><P></P><P>I have a field called Fiscal Period that goes from 1-12, when the year is over. Now I have 1 and 2.</P><P></P><P>Then I would like to say that when the report is opened, then it should open with filter on MAX (Fiscal Period) = 2, but I can not get it to work. If I type in 2, then it works. </P><P></P><P>Any help here? I have tried the formula MAX, MAXstring, NUMmax..</P><P></P><P>Best regards</P><P></P><P>Bjarne</P></BODY></HTML> Fri, 02 Nov 2012 09:48:19 GMT https://community.qlik.com/t5/QlikView/Formula-in-trigger/m-p/395877#M147628 2012-11-02T09:48:19Z Re: Formula in trigger https://community.qlik.com/t5/QlikView/Formula-in-trigger/m-p/395878#M147629 <HTML><HEAD></HEAD><BODY><P>Bjarne,</P><P></P><P>Based on your description, I'd say that this should work:</P><P>=max("Fiscal Period")</P><P></P><P>If not, something's missing in your description, and you need to upload a sample application.</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Fri, 02 Nov 2012 09:52:35 GMT https://community.qlik.com/t5/QlikView/Formula-in-trigger/m-p/395878#M147629 Anonymous 2012-11-02T09:52:35Z Re: Formula in trigger https://community.qlik.com/t5/QlikView/Formula-in-trigger/m-p/395879#M147630 <HTML><HEAD></HEAD><BODY><P>Dohh</P><P></P><P>I did not use the "=" sign. That was it. Thanks</P></BODY></HTML> Fri, 02 Nov 2012 09:57:14 GMT https://community.qlik.com/t5/QlikView/Formula-in-trigger/m-p/395879#M147630 2012-11-02T09:57:14Z