Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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