Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
Not applicable

How to make a default multiple selection

Does anybody know how to have a dynamic selection onActivateSheet or similar, which selects all weeks from week 1 and until current date. I am doing a cost/budget comparison, and needs to have all pasts weeks selected. I have a field to hold the week number : k_Week.

First, I tried to make a search to establish a bookmark, but I cannot come up with the right expression. Tried expressions like this: "<=week(ReloadTime())", but without luck. Neither I can search with =Week(Today()). This selects all weeks every time.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: How to make a default multiple selection

Create a variable in the script: LET vWeek = week(today());

Then add a Select in Field action to the OnActivateSheet trigger with k_Week as Field and ='<=' & $(vWeek) as search string.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Not applicable

Re: How to make a default multiple selection

MVP & Luminary
MVP & Luminary

Re: How to make a default multiple selection

Create a variable in the script: LET vWeek = week(today());

Then add a Select in Field action to the OnActivateSheet trigger with k_Week as Field and ='<=' & $(vWeek) as search string.


talk is cheap, supply exceeds demand

View solution in original post