topic Re: Bookmarks stop working after document overwritten with a new version in QlikView

Bookmarks stop working after document overwritten with a new version

Wed, 29 Feb 2012 17:11:23 GMT

Hello QlikView experts,

Could you please help with the following issue?

A number of shared server bookmarks were created by users on a document in the live server of our QlikView 10 landscape. These bookmarks worked up to the point of overwriting the document with a more recent version of the document. The new version differed in that it contained a few newly added fields.

According to the QlikView reference manual if a document contains the relevant fields the bookmarks should still work. I cannot see any fields which have been changed/removed, only newly added ones. Are there any other reasons which can result in bookmarks not functioning after an overwrite?

Many thanks in advance.

Best,

Aleks

Bookmarks stop working after document overwritten with a new version

Thu, 01 Mar 2012 09:14:29 GMT

After some bookmark testing, I have found out why the bookmarks from the old version of the document stopped working in the new one. The reason was a field which was added to the new version. The old bookmarks did not contain selection data for this field as it did not exist in the old version.

This would not be a problem normally, but that field had a setting which requires it to always have one value selected. When executed the bookmarks start by removing the selections on any fields for which they have got no selection data and because this was impossible for the new field, they would not work.

What is also interesting to note is that bookmarks created on the new version (i.e. containing a selection on the new field) worked without problems for the old version of the document. In other words reducing the number of fields with current selections in a document does not seem to be a problem for bookmarks created in previous document versions.

I hope the above helps anyone who ends up facing a similar issue.

Re: Bookmarks stop working after document overwritten with a new version

Jason_Michaelides — Thu, 24 Jan 2013 16:55:22 GMT

Aleks,

I want to thank you for taking the time to explain this issue and the solution so well. We have just had exactly the same problem on our production system after a new release last night and thanks to your post here I have been able to fix it in a reasonable timeframe.

This really highlights that this is a community and not just a Q&A forum. I hope others see this and follow your example.

Thanks again,

Jason

Re: Bookmarks stop working after document overwritten with a new version

Fri, 25 Jan 2013 08:41:42 GMT

Hi Jason,

Thanks for the reply. I remember how much time it took me to figure this one out and I am very happy that my post has saved someone else that time.

Best wishes,

Aleks

Re: Bookmarks stop working after document overwritten with a new version

Tue, 21 Jan 2014 19:41:00 GMT

Hi Aleks,

This solution helped me a year after this was posted on a very critical day. So thank you very much.

I would also like to mention that the solution, (which was not immediately obvious to me and had to play around for a few minutes) to this issue is that the user who created the bookmark should click on the bookmark, which will yield the empty result and then select the value of the filter (the additional column which must have a value), which will then yield the required result set and then save the bookmark. Hope this helps someone too.

Amitesh

Re: Bookmarks stop working after document overwritten with a new version

udaya_kumar — Tue, 08 Jul 2014 13:26:27 GMT

Hi Aleksandar,

What else can be done to make the bookmark work with the newer file with new field,

Without creating new bookmark for the new file.

Re: Bookmarks stop working after document overwritten with a new version

Wed, 09 Jul 2014 12:38:34 GMT

Hi Uday,

If you are able to export the bookmark as an xml file (I'm not sure which kinds of bookmarks could be exported) you could try to change the xml definition, but I don't think this is very easy and might have unpredicted negative consequences.

It seems to me that the safest option is to recreate the bookmark.

Aleks

Re: Bookmarks stop working after document overwritten with a new version

udaya_kumar — Wed, 09 Jul 2014 12:58:51 GMT

Thanks for the reply Aleksandar...

I will try creating new bookmarks...

Re: Bookmarks stop working after document overwritten with a new version

udaya_kumar — Thu, 10 Jul 2014 07:35:25 GMT

Hi Aleks,

Can we add a trigger to select a value on the new field with the existing bookmark?

will it solve the problem?

Re: Bookmarks stop working after document overwritten with a new version

Thu, 10 Jul 2014 09:30:11 GMT

Hi Uday,

Do you mean adding two triggers on opening the document: one to select a value in the new field, and another to activate the bookmark? If so, I wouldn't recommend this as the bookmark would apply to everyone who opens the document, while not everyone might need it to be applied in such a default way.

It also depends on whether the new field is set to 'Always One Selected Value'. If this is the case the bookmark is not going to work anyway as it first tries to clear the selection on all fields which it does not include and this is not going to be possible for the new field.

I hope this helps.

Aleks

Re: Bookmarks stop working after document overwritten with a new version

udaya_kumar — Thu, 10 Jul 2014 10:14:41 GMT

Hi Aleks,

Thanks for the reply.

My problem is,

Users saves bookmarks in accesspoint.

Now we have added a new field in the data model and that field has selection in the application.

Now if a user do some selections in the accesspoint, then if he selects his saved bookmark before this field was added.

then the saved bookmark is not working.

Is there any work around for this to get the saved bookmark work and also the selection should remain in the new field added in the application?

Re: Bookmarks stop working after document overwritten with a new version

Thu, 10 Jul 2014 10:25:48 GMT

Hi Uday,

The only solution options I can think of in this case are the ones I mentioned above (post from Jul 9, 2014 8:38 AM). Bookmarks are very handy but can turn into quite a big support challenge in my experience.

Aleks

Re: Bookmarks stop working after document overwritten with a new version

sarangmmehta — Thu, 11 Feb 2016 05:55:22 GMT

Hi Aleksandar,

Thanks for the solution to this 'bookmark issue'.

But in my scenario (User has created a bookmark by selecting 150 values from a single field and few other fields)

and now there are multiple requests to add new fields every 2 weeks.

In that case, this bookmark issue can create a lot of problems and we can't ask users to create a new bookmark again.

We are using QV 11.2 SR5.

Kindly suggest an alternate if possible.

Regards,

Sarang

Re: Bookmarks stop working after document overwritten with a new version

Thu, 11 Feb 2016 09:45:27 GMT

Hi Sarang,

I am not sure the challenge you have relates to the issue I described above. In my case the culprit was a field with "Always one value selected" and you mention that in your situation a field has 150 values selected. This indicates that the selections in this field can be cleared so bookmarks which start by clearing all selections should work.

Do you have any fields where "Always one value selected" is enabled? Do the users need the bookmark(s) to select values in the newly added fields?

In any case there seem to be two options for editing a bookmark:

1. Recreate the bookmark and choose to replace the old one. This works with document bookmarks, but you would need to test if the URLs of the old bookmarks are still going to work (for people who call the bookmarks using this approach).

2. Export the bookmark, edit its XML definition, and import it again. I have not ventured into doing this so I can't really advise you here.

If enough users are using a particular bookmark there might be a case for creating a separate Sheet or indeed separate QVW to replace the bookmark.

I hope this helps.

Kind regards,

Aleks

Re: Bookmarks stop working after document overwritten with a new version

krishna20 — Thu, 18 Aug 2016 06:33:14 GMT

Hi Aleksandar,

I know this post as old one. Please suggest me how to do this.

I have created 5 Document bookmarks at qvw. We are having nearly 350 users to access this APP through access point. These 350 users want to edit or update those bookmarks by including two or more fields when required in document bookmarks. Is this possible to update a bookmark through browser.

Re: Bookmarks stop working after document overwritten with a new version

Thu, 18 Aug 2016 07:18:07 GMT

Hi Kalyan,

As far as I know document bookmarks can only be updated from the desktop client. It might be worth googling this one up, though, as I haven't dealt with QlikView document bookmarks in a while.

Do the new bookmarks need to be document ones? Document bookmarks are arguably easier to manage, but if the users are keen to create new ones quickly it is probably easier for them to apply the document bookmarks as a starting point. Then the required additional/changed filters can be made and the resulting selections saved as new user bookmarks. The latter can be shared if required.

I hope this helps.

Aleks

Re: Bookmarks stop working after document overwritten with a new version

sunny_talwar — Thu, 12 Jan 2017 19:37:41 GMT

Very helpful, would have spent more time had it not been for you explaining what was causing the issue.

Best,

Sunny

Re: Bookmarks stop working after document overwritten with a new version

Fri, 03 Feb 2017 09:45:30 GMT

Thanks for the comment and I'm glad that this has helped.

Aleks