Date Range Selection Not Working

jfredericks — Fri, 29 May 2020 15:04:27 GMT

Hello,

I have buttons set up to filter based on date ranges (All Time, Last Month, and Last Week). The All Time and Last Month filters work correctly, but the Last Week filter is having issues.

Here are both my expressions [where vEndDate = Now()]

Last Month: =Date(Addmonths(vEndDate,-1),'M/DD/YYYY hh:mm:ss tt')

Last Week: =Date(vEndDate -7,'M/DD/YYYY hh:mm:ss tt')

I have a trigger set on vStartDate and vEndDate to Select in Field for my date field, where the search string is: ='>='&vStartDate&'<='&vEndDate

If I select Last Month, it sets the search string correctly, but if I select Last Week, it sets - as the date range.

I am also confused because if I change the value I subtract from vEndDate from 7 to an integer greater than 7, the filter seems to work fine.

Re: Date Range Selection Not Working

jfredericks — Wed, 10 Jun 2020 14:01:05 GMT

Update: no data was available to select in the field. Set expressions to conditional in related charts and changed the expressions disabled error message to "No data available in selected date range"

topic Date Range Selection Not Working in QlikView

Date Range Selection Not Working

Re: Date Range Selection Not Working