Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jamesmf1982
Contributor III
Contributor III

Selecting current week / month when changing tabs

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

1 Solution

Accepted Solutions
techvarun
Specialist II
Specialist II

Looking for something like the attached?

View solution in original post

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jamesmf1982
Contributor III
Contributor III
Author

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
techvarun
Specialist II
Specialist II

Looking for something like the attached?

View solution in original post

jamesmf1982
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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
Master II
Master II

see attached

hope this helps

oscar_ortiz
Partner
Partner

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