Discussion board where members can get started with QlikView.
I want to create a button for my dashboard that pulls in leads created for the current week. I essentially want to give the end users the ability to click the "this week" button, and only show data for leads created during the current week.
Create a button named "this week" and use action - Select in field.
in Field -give Week field
in Search String -give "=Week(Today())"
Hope it helps.
This depens ofcourse on your data.
Assuming you have a Date field you can create a week field in your loading script by using:
Year(DateField) as Year,
Week(DateField) as Week,
Now you can create a button with 2 actions
action 1 : Select in field
Field : Year
Search String: =Year(Today())
action 2 : Toggle Selection
Field : Week
Search String: =Week(Today())
This will select the current year and then the current week.
Dont forget to select the current year, else it will select all current weeknumbers also of the previous years.