topic Re: Listbox Date search string problem in QlikView

Listbox Date search string problem

Fri, 11 Jul 2014 16:09:04 GMT

I have created these variables ...

LET vTodaysDate = today();
LET vTodaysDate = Date(vTodaysDate);
LET vPast7Days = Date(vTodaysDate-7);

Have a listbox for a date field. When I input this >=01-07-14 <07-07-14 in the list box search I get the dates in between. I want to do the same but using the variables above >=vPast7Days <vTodaysDate so that then I can create a bookmark, but it will not work with the variables.

Have tried many different formats how to input the variables but still not working. How should it be done?

Re: Listbox Date search string problem

m_woolf — Fri, 11 Jul 2014 16:13:39 GMT

Have you tried using dollar sign expansion with the variables?

Re: Listbox Date search string problem

Fri, 11 Jul 2014 16:13:58 GMT

try referencing the variables like this:

$(vPast7Days) < $(vTodaysDate)

Re: Listbox Date search string problem

Mon, 14 Jul 2014 07:17:10 GMT

Tried this .... $(vPast7Days) < $(vTodaysDate) ... but it selects all the dates in the calendar instead of only the range I need. So puzzled

Re: Listbox Date search string problem

tresB — Mon, 14 Jul 2014 07:28:19 GMT

This works:

=Date>'$(vFrom)' and Date<'$(vTo)'

Re: Listbox Date search string problem

aveeeeeee7en — Mon, 14 Jul 2014 07:31:33 GMT

Hi Alex

I advice you to create a Button

Add Action Select in Field

Field Name:

Your Date Field

Search String:

='>=$(=date(today()-7))' & '<$(=date(today()))'

Kindly see the Attachment.

Regards

Aviral Nag

Re: Listbox Date search string problem

Mon, 14 Jul 2014 08:32:04 GMT

Although not exactly what I wanted but this works well enough for me. This forum is an excellent resource thanks to you guys. Keep it up.

Re: Listbox Date search string problem

Mon, 14 Jul 2014 08:37:02 GMT

This works also 🙂