topic Selecting Date Range with a button in QlikView

Selecting Date Range with a button

Thu, 06 Jun 2013 16:31:13 GMT

I have a question about selecting a date range using a button and the SELECT IN FIELD function.

I have a field called Date Wanted that I load as follows: Date([Date Wanted]) as [Date Wanted]

This Date Wanted field is the appointment date for a field visit.

I am trying to find any appointments due in the next two weeks via a single button instead of individuall selecting each date.

To begin I have tried to simply select today and have had no success:

Actions - Select in Field

Field - [Date Wanted]

Search String - =today()

How can I select Today? And how can i select a date range from today to 14 days in the future? (for example 6/1/2013 to 6/14/2013)

Thu, 06 Jun 2013 17:08:22 GMT

Create a variable to capture today() result and use that variable in the search string.

Hope this helps.

er_mohit — Fri, 07 Jun 2013 06:17:04 GMT

wirte in search string

=date(today())+14

hope it helps

Sokkorn — Fri, 07 Jun 2013 06:31:55 GMT

Hi jasonzola,

Do this way:

1. Make sure your field [Date Wanted] have this format DD-MMM-YYYY (you can change format what you want)

2. Create button with select in field action (for filter Today())

. Field: [Date Wanted]

. Search String: =Date(Today(),'dd-MMM-yyyy')

3. Create a new button with select in field action (for filter Today()+14)

. Field: [Date Wanted]

. Search String: ='>=' & Date(Today(),'dd-MMM-yyyy') & '<=' & Date(Today()+14,'dd-MMM-yyyy')

See sample attache file

Regards,

Sokkorn