topic Re: Bookmark as an expression do not work in QlikView

Bookmark as an expression do not work

MindaugasBacius — Sat, 02 Apr 2016 17:13:50 GMT

Hello

I am trying to make a bookmark as an expression.

Into a list just write simple expression =[Date]=today()-second(now()) and save it as with this settings:

The thing is that the bookmark saves date as a static value but I need it to be a dynamic.

Am I missing something?

Thank you!

Re: Bookmark as an expression do not work

swuehl — Sat, 02 Apr 2016 17:20:12 GMT

Seems to work for me after repeating your steps.

Re: Bookmark as an expression do not work

MindaugasBacius — Sat, 02 Apr 2016 17:34:27 GMT

Have you tried to use the Bookmark?

Do the date value change when you choose the Bookmark?

Re: Bookmark as an expression do not work

swuehl — Sun, 03 Apr 2016 00:03:35 GMT

Not with your original file because it selected a constant value.

But I just replicated your search, checked that current selection status showed the search and recreated the bookmark.

As I said, it seems to work for me, and it is selecting different values when time changes.

Have you had a look at my sample I've attached above?

Re: Bookmark as an expression do not work

MarcoWedel — Sun, 03 Apr 2016 01:05:36 GMT

Hi,

I remember an issue with storing search expressions in bookmarks when the search returns only one value.

You could manually edit the search expression in an exported bookmark (xml) and reimport it as a workaround.

I'll try to find a description of this issue.

hope this helps

regards

Marco

Re: Bookmark as an expression do not work

MarcoWedel — Sun, 03 Apr 2016 01:14:20 GMT

maybe this helps:

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

regards

Marco

Re: Bookmark as an expression do not work

swuehl — Sun, 03 Apr 2016 11:54:16 GMT

Yes, I think Marco is right, that might be your issue.

I remember I had similar issues in the past:

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

Looks like you are running 11.20.12904.0409, so you might experience exactely what Marco referenced above.

Seems like it works now in QV12 IR, it stores the search correctly in the bookmark and the search returns different results over time:

Re: Bookmark as an expression do not work

MindaugasBacius — Sun, 03 Apr 2016 18:17:20 GMT

I have asked for permission to read the post.

I guess for now I will try to make a manual changes in exported bookmark document.

Re: Bookmark as an expression do not work

MindaugasBacius — Sun, 03 Apr 2016 18:22:54 GMT

11.20.12904.0409 you are absolutely right about my version.