topic Re: How to preselect dates when sheet is active? in QlikView

How to preselect dates when sheet is active?

Fri, 13 Jul 2012 11:45:59 GMT

Hi,

I have a problem regarding the preselection of dates when specific sheet is loaded. I am using QV11. I want that all the dates of today and all the consecutive days are selected of my listbox when I access this sheet.
I know that have to access 'Sheet properties' -> 'Add actions' -> 'Select in Field' -> 'Field' and 'Search String'

The specific field is 'date_valid_until'.

I have tried the following 'Search String': ='>=' & Today() but then all the dates that start in 2012 and all the following dates are selected. So I am almost there but not quite because it must start today and not from 01-01-2012

I also tried: ='>=' & Date(floor(Today()),'DD-MM-YYYY') but then nothing happens.

Can anybody help?

see attached file: 'activate_dates_sheet.qvw'

Kind regards,

Byron

Re: How to preselect dates when sheet is active?

Fri, 13 Jul 2012 12:02:56 GMT

send a qvw file please:)

Re: How to preselect dates when sheet is active?

Fri, 13 Jul 2012 12:35:02 GMT

See attachment now.

Re: How to preselect dates when sheet is active?

Fri, 13 Jul 2012 12:39:21 GMT

firstly change your date format in script from 'YYYY' to 'YYYY-MM-DD'

reload and send qvw again:P

Re: How to preselect dates when sheet is active?

Fri, 13 Jul 2012 12:48:24 GMT

That was the problem all along. Thanks for pointing that out.