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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulceking
Contributor
Contributor

Setup Default Public Bookmark with Current Year and Month

Hi,

I am struggling to setup a bookmark which defaults the filter to the current month and year.

I've tried writing an expression within the filter as per this youtube video (https://www.youtube.com/watch?v=tFyqOigqnUw) but no matter what I do it just wont work - it simply creates a bookmark and hardcodes the current month selected in the bookmark expression.

My filter field is called start.autoCalendar.YearMonth and I've tried variations of the following expression =start.autoCalendar.YearMonth=MonthStart(Now())

Any help to understand what I am doing wrong would be much appreciated.

Labels (2)
1 Reply
vinieme12
Champion III
Champion III

create a variable:    =MonthStart(Now())

and use a variable filter

 

OR

 just apply filter as

 =MonthStart(Now())       

 

not  =start.autoCalendar.YearMonth=MonthStart(Now())

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.