topic Using a formula in a bookmark in QlikView https://community.qlik.com/t5/QlikView/Using-a-formula-in-a-bookmark/m-p/391542#M146044 <HTML><HEAD></HEAD><BODY><P>I want a bookmark that automatically selects the previous work day.</P><P></P><P>I can type it into the listbox search as follows:</P><P></P><P>=ActivityDate=FirstWorkDate(today()-1,1)</P><P></P><P>and it works fine, but when I try to add a bookmark, it just gives me a static date.</P><P></P><P>How do I make it dynamic?</P><P></P><P>Thanks,</P><P></P><P>Kevin</P></BODY></HTML> Tue, 23 Apr 2013 15:45:01 GMT 2013-04-23T15:45:01Z Using a formula in a bookmark https://community.qlik.com/t5/QlikView/Using-a-formula-in-a-bookmark/m-p/391542#M146044 <HTML><HEAD></HEAD><BODY><P>I want a bookmark that automatically selects the previous work day.</P><P></P><P>I can type it into the listbox search as follows:</P><P></P><P>=ActivityDate=FirstWorkDate(today()-1,1)</P><P></P><P>and it works fine, but when I try to add a bookmark, it just gives me a static date.</P><P></P><P>How do I make it dynamic?</P><P></P><P>Thanks,</P><P></P><P>Kevin</P></BODY></HTML> Tue, 23 Apr 2013 15:45:01 GMT https://community.qlik.com/t5/QlikView/Using-a-formula-in-a-bookmark/m-p/391542#M146044 2013-04-23T15:45:01Z