topic Bookmark selection using expression in QlikView

Bookmark selection using expression

Mon, 11 May 2015 14:27:06 GMT

Hi all,

I am currently trying to setup a bookmark that will always select the date values from the start of the month until Today()-1. I have already got a button which can do this selection using the following expression:

='>=$(=MonthStart(Today()))<$(=Date(Today()))'

The problem with this is that if I save the selection as a bookmark this does not automatically update when generating reports the next day and therefore it is necessary to reapply the selection, re-upload to the server and then generate reports which is quite time consuming.

I read here on the forums that if I create a bookmark using a search expression in the date list box then the bookmark will (hopefully!!) update itself each time a report is generated. I am now trying to set this up, but the above expression clearly does not work in the search field of the date list box.

Can someone therefore please advise how the expression can be modified for it to work in the search field of the date list box?

Many thanks in advance.

Armend

Re: Bookmark selection using expression

mrossoit — Mon, 11 May 2015 14:43:46 GMT

Hi,

I can't do a test on server at the moment, I'm sorry, but have you tried to use today function with timer_mode setted to 1?

today(1) give you current date at the moment of function calling.

Hope it helps

Re: Bookmark selection using expression

Mon, 11 May 2015 14:49:01 GMT

Hi Massimiliano,

Thank you for your response. I have tried using the Today(1) function but this does not seem to apply the correct selection either.

This does not need to be tested on the server by the way, I just need an expression (similar to the expression in my original post) that will select the dates from the start of the month until yesterday using the search function of the date list box.

Hope this makes it clearer.

Thanks,

Armend