Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Default Selection in List Box of Week

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?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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

Not applicable
Author

This is working fine!

Thanks a lot for your help