topic Re: Selecting current week / month when changing tabs in QlikView

Selecting current week / month when changing tabs

jamesmf1982 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Selecting current week / month when changing tabs

Anil_Babu_Samineni — Wed, 02 Aug 2017 07:16:13 GMT

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 ??

Re: Selecting current week / month when changing tabs

jamesmf1982 — Wed, 02 Aug 2017 08:19:26 GMT

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.

Re: Selecting current week / month when changing tabs

Anil_Babu_Samineni — Wed, 02 Aug 2017 08:38:34 GMT

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?

Re: Selecting current week / month when changing tabs

techvarun — Wed, 02 Aug 2017 08:55:20 GMT

Looking for something like the attached?

Re: Selecting current week / month when changing tabs

jamesmf1982 — Wed, 02 Aug 2017 10:49:57 GMT

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.

Re: Selecting current week / month when changing tabs

jamesmf1982 — Wed, 02 Aug 2017 10:51:30 GMT

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.

Re: Selecting current week / month when changing tabs

Frank_Hartmann — Wed, 02 Aug 2017 11:55:13 GMT

see attached

hope this helps

Re: Selecting current week / month when changing tabs

oscar_ortiz — Wed, 02 Aug 2017 13:08:20 GMT

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