topic Re: How to make a default multiple selection in QlikView

How to make a default multiple selection

Thu, 06 Feb 2014 18:00:47 GMT

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.

Re: How to make a default multiple selection

Thu, 06 Feb 2014 18:18:19 GMT

Try the below

Action select field multiple values- YTD

Re: How to make a default multiple selection

Gysbert_Wassenaar — Thu, 06 Feb 2014 18:28:51 GMT

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.