QlikView App Dev

[#1]

Hi,

I have made a OnActiveSheet Avent Trigger, Select in Field action, for a Date field. It is working fine with the following Search String

='>=$(=Date(today()-30))<=$(=Date(today()+30))'

In my Date List Box current day +- 30 days are selected.

But when I am trying to do the same with a Week field I cannot get it working. Week field is made by WeekName() function in a script.

I have tryed the following Search String:

='>=$(=WeekName(today()-30))<=$(=WeekName(today()+30))'

Any ideas how should I do that?

[swuehl · Accepted solution]

Try something like

='=WEEKFIELD>= '& chr(39) & '$(=Weekname(today()-30))' & chr(39) & ' and WEEKFIELD <=' & chr(39) & '$(=Weekname(today()+30))' &chr(39)

Replace WEEKFIELD by your week field name.

Hope this helps,

Stefan

[#3]

This is working fine!

Thanks a lot for your help