Selecting current week / month when changing tabs

[jamesmf1982]

Hi,

I have a report which has two tabs, one relating to monthly data using a field called CalendarMonthAndYear and one called CalendarWeekStart.

I know by creating a trigger I can clear the current month / week, but how do I create a trigger to select the current month / week?

Thanks

James

[Anil_Babu_Samineni]

Better if you provide sample application and just to know, What trigger you want to apply? You want to select default month / week on what basis and when ??

[jamesmf1982]

Sorry realised I wasn't clear at all. I am unable to upload a sample at the moment, but basically, when I move from one tab to another I want to clear the Month selection and replace it with the current week selection, or vice versa depending on which tab I am going too.

I am using a clear field trigger as an OnLeaveSheet command, but in the OnActiveSheet I want to have the trigger to select the week.

Hope this makes a bit more sense.

[Anil_Babu_Samineni]

Okay, Let's consider it has my example

You have two sheets in your Dashboard. Each sheet has some objects.

Sheet1 -- Week and Month as filters

Sheet2 -- Week and Month as filters

Now, When we open work file automatically you want to navigate Sheet1 and then Max(Week) selection. Then when you move into second sheet what are you expecting here?

[techvarun · Accepted solution]

Looking for something like the attached?

[jamesmf1982]

That's almost it, the MAX would work great but it our refresh looks 4 weeks in the future so the Max bumps it up. I would need it to look at the current week / month.

[jamesmf1982]

Hi, pretty much that but it can't be the MAX date as we look in the future by 4 weeks and this throws it off a bit.

[Frank_Hartmann]

see attached

hope this helps

[oscar_ortiz]

James,

Normally I would go through the process of creating variables in my script to set current time period values.  Then I would use those variables values in my trigger selection.

vCurrentYear

vCurrentMonth

vCurrentWeek

Good luck

Oscar