Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

current week selection

Hi everyone,

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.

Any ideas?

Thanks!

Meghan

3 Replies

Re: current week selection

hi,

     Try this,

     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.

dennisnet
Valued Contributor III

Re: current week selection

Hi Meghan,

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.

dennisnet
Valued Contributor III

Re: current week selection

Dont forget to select the current year, else it will select all current weeknumbers also of the previous years.

Community Browser