topic Default Selection in List Box of Week in QlikView

Default Selection in List Box of Week

Mon, 09 Jan 2012 06:39:12 GMT

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 — Mon, 09 Jan 2012 10:14:33 GMT

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

Mon, 09 Jan 2012 10:48:22 GMT

This is working fine!

Thanks a lot for your help