topic Re: Date range selection problem in QlikView

Date range selection problem

Mon, 05 Jan 2015 22:28:04 GMT

I've created a date Input selection box.

I selected Call Activity From >= 12/01/2014 and Call Activity To <= 12/06/2014.

It only shows records from 12/01/2014 - 12/05/2014. I do have records for 12/06/2014 that didn't show up in the report. It show record one day less than the last date selected.

How to resolve this? Thanks!!

I had set the Variable Event triggers Action as below for the expression:

For Call Activity From

='>=' & CallActivitiesFrom & '<=' & CallActivitiesTo

For Call Activity FromTo

='>=' & CallActivitiesFrom& '<=' & CallActivitiesTo

Re: Date range selection problem

Josh_Good — Mon, 05 Jan 2015 23:20:08 GMT

Hi Suzanne,

I would recommend you check that your dates are not actually date-times. If they are then all of your data connected to 12/06/2014 would be great than the parameters you indicated. You can check this by extending you range to 12/07/2014 and see if the data from the 6th appears. You could also check this by putting the dates into a listbox and changing the formatting to datetime.

-Josh

Qlik

Re: Date range selection problem

Tue, 06 Jan 2015 15:15:33 GMT

it doesn't seems to work.

Re: Date range selection problem

Josh_Good — Tue, 06 Jan 2015 15:24:49 GMT

I've attached the file again and check that it is working on my end. Let me know if it doesn't work for you.

-Josh

Qlik