topic Re: Clear All On Open Trigger Bug? in QlikView

Clear All On Open Trigger Bug?

alexandergrando — Fri, 14 Jul 2017 18:14:03 GMT

Hello,

I am trying to have my document automatically select the max calendar year on open. I am trying to use document triggers to accomplish this. My first trigger is a Clear All. The next trigger is: =max(CalendarYear). Please see screenshot below.

The problem is that I only get the correct max year if no year was selected in the prior save. Otherwise, the year will show up as the one last saved despite the Clear All trigger and the Select in Field trigger.

Can anyone please help? Is this a bug?

Message was edited by: Alexander Grando Reason: Attached sample app.

Re: Clear All On Open Trigger Bug?

juan_patrick — Fri, 14 Jul 2017 18:26:21 GMT

Hi Alexander,

Try this:

=max( {1} CalendarYear)

Re: Clear All On Open Trigger Bug?

alexandergrando — Fri, 14 Jul 2017 18:40:05 GMT

Hi Juan,

Thanks for the response. Your expression works.

I also need to select the max MonthName in addition to the year. I tried including an additional Select in Field trigger with an alteration of your expression, but it didn't work.

Do you suppose you can help me out with this also? Thanks.

Re: Clear All On Open Trigger Bug?

juan_patrick — Fri, 14 Jul 2017 18:50:13 GMT

Alexander,

You can create a Flag in script for max year & month, and in the trigger you use only this field (the flag).

Or you can try this:

=max( {1<CalendarYear={"=$(=max({1}CalendarYear))"} >} monthnamefield )

Re: Clear All On Open Trigger Bug?

Anonymous — Fri, 14 Jul 2017 19:23:26 GMT

If possible I would create a field in my data model that is a date for the first of the month. Then all you have to do is 1 trigger like

=max({1} MonthDate)

Re: Clear All On Open Trigger Bug?

alexandergrando — Fri, 14 Jul 2017 20:06:44 GMT

Juan,

I tried your new expression, but was unable to get it to work. I am attaching a sample app. Can you please show me how to set up the flag field? I am also OK with any other method to get this to work.

Re: Clear All On Open Trigger Bug?

alexandergrando — Fri, 14 Jul 2017 20:09:23 GMT

Hi Wallo,

I actually already have a single field that I can use to get the max date. But the reason I want to do one separately for year and another for month is to bring attention to the listboxes via the the green highlight color. Otherwise, they are only colored white if indirectly selected. Please have a look at my app above if you want.

Re: Clear All On Open Trigger Bug?

alexandergrando — Mon, 17 Jul 2017 17:41:10 GMT

Hi,

I just want to bump this thread because it has been several days since I've received a reply and my question remains unanswered.

Re: Clear All On Open Trigger Bug?

Anonymous — Wed, 19 Jul 2017 16:44:19 GMT

Second action on CalendarMonthName for Select in Field.

=Month(MakeDate(max({1}CalendarYear), max({1<CalendarYear={'$(=max({1}CalendarYear))'}>}CalendarMonthName), 1))