Discussion Board for collaboration related to QlikView App Development.
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?
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 ??
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.
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?
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.
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.