topic Re: Bookmark exact selection, not all selections containing substring in QlikView

Bookmark exact selection, not all selections containing substring

Wed, 23 Dec 2015 15:42:07 GMT

I am trying to create a bookmark with a list of products selected. My list box looks like this:

Product Name:

Apple

Banana

Banana Creme Pie

Coffee

If I select Apple and Banana and create a bookmark, when I apply the bookmark it returns Apple, Banana and Banana Creme Pie. I would like it to return only Apple and Banana.

Re: Bookmark exact selection, not all selections containing substring

Gysbert_Wassenaar — Wed, 23 Dec 2015 18:48:08 GMT

I can't reproduce this behaviour. Can you post a small qlikview document that demonstrates the problem?

Re: Bookmark exact selection, not all selections containing substring

Wed, 23 Dec 2015 20:20:03 GMT

I created a new qvw so I could post it here, and found it doesn't replicate the behavior. It is interesting that in my new qvw, the current selections shows Apple,Banana and the bookmark works as expected. In my app, the current selection shows ("Apple"|"Banana"). This is because I am doing a Select in Field in order to select the product names in the list box. In my Select in Field, I am adding the parenthesis, double quotes and pipes. I thought I needed all of that in order to be able to select products with spaces in the name.

Re: Bookmark exact selection, not all selections containing substring

Gysbert_Wassenaar — Thu, 24 Dec 2015 06:45:16 GMT

What's the default search mode for that document set to? You can check that on the Presentation tab of the Document Properties window.

Re: Bookmark exact selection, not all selections containing substring

Thu, 24 Dec 2015 13:35:29 GMT

The default search mode is Use Normal Search.

Re: Bookmark exact selection, not all selections containing substring

Gysbert_Wassenaar — Thu, 24 Dec 2015 17:02:30 GMT

Sorry, no idea then

Re: Bookmark exact selection, not all selections containing substring

Sun, 03 Jan 2016 19:49:04 GMT

I got the answer from Qlik Support. They suggested adding Select Possible to the actions after the Select in Field, and that worked.