topic Re: Always One Selected Value In Bookmark - Dynamically update to most recent date? in QlikView

Always One Selected Value In Bookmark - Dynamically update to most recent date?

kmstephenson — Thu, 22 Dec 2016 15:57:03 GMT

Hi All,

I have some selections that I created a bookmark for. One of the selections is a date field, which is set to always one selected value. When the date field updates to add an additional month when new data is pulled in, I'd like the date in the bookmark to be set to the most recent month, instead of displaying the month when the bookmark was created. Is this possible?

Thanks!

Re: Always One Selected Value In Bookmark - Dynamically update to most recent date?

Anonymous — Thu, 22 Dec 2016 19:53:33 GMT

Straight forward not possible. But you can create a variable/flag field and assign current month to that. Now your book mark should get that value. Like currentmonth -> value flag - > Book mark.

Re: Always One Selected Value In Bookmark - Dynamically update to most recent date?

MarcoWedel — Thu, 22 Dec 2016 23:05:39 GMT

Hi,

you can use expression search strings in bookmarks:

The Search String

The Expression Search

Maybe you can post a sample application to demonstrate?

hope this helps

regards

Marco

Re: Always One Selected Value In Bookmark - Dynamically update to most recent date?

kmstephenson — Fri, 23 Dec 2016 14:52:18 GMT

Can you provide an example for selecting maximum date if that date field has Always One Selected Value checked? None of the expressions I've tried seem to work

Re: Always One Selected Value In Bookmark - Dynamically update to most recent date?

kmstephenson — Mon, 29 Jan 2018 21:30:37 GMT

Any updates on this? How to get around Always One Selected Value for date field - I'd like the bookmark to always use the most recent date from this field.

Re: Always One Selected Value In Bookmark - Dynamically update to most recent date?

MarcoWedel — Tue, 30 Jan 2018 00:26:50 GMT

Hi,

one example using an expression search bookmark:

=Only({1} Month)=Max({1} total Month)

There used to be an issue though that prevented bookmarks from actually storing the expression when it returns only one single value, maybe that's what caused the issue in your case either:

QV11.20SR6: Bookmark with search expression does not work as in QV11

https://community.qlik.com/blogs/qlikviewdesignblog/2015/03/02/the-search-string#comment-33888

Re: Bookmark as an expression do not work

In this example I corrected the bookmark by exporting as xml, editing the expression and reimporting it.

Edit: Seems like I accidently used an old QV version. The current version doesn't show this behaviour.

hope this helps

regards

Marco