topic Combining Bookmarks - very slowly. in QlikView

Combining Bookmarks - very slowly.

hdonald — Thu, 29 Jul 2010 14:38:59 GMT

While trying out set analysis syntax to combine Bookmarks (using Qv9 SR4),

e.g. =sum( {$ * (BM01+BM02) } ForecastSales ),

I'm getting very slow response times depending on how the Bookmarks are created.

If BM01 is created by a macro (ActiveDocument.CreateDocBookmark false, HDBM01, BM01, 1 ) response time is 200 seconds.

If BM01 is created manually with the same settings, as a shared server bookmark, response time is 1 second.

Both give the same, correct, result but why the slow response on macro created server bookmarks ?

Can I do anything about this ?

Combining Bookmarks - very slowly.

jonathandienst — Thu, 29 Jul 2010 15:03:08 GMT

Are you sure that the bookmark created by the macro is identical to that created manually?

Check the current selections after applying each of them.

Hope this helps

Jonathan

Combining Bookmarks - very slowly.

hdonald — Thu, 29 Jul 2010 15:59:47 GMT

Yes - I've just checked again and the selections (only 3 fields selected) are the same.

I've created BM01 with the macro - noted the long response - then recalled BM01 and saved manually as BM02.

BM02 then responds in 1 or 2 seconds when used in the set analysis syntax while the original takes 3+ minutes.

The sheet being bookmarked does contain an input field - could that be a problem ?.

I don't see an option for 'CreateDocBookmark' to save Input Field values.

Combining Bookmarks - very slowly.

jonathandienst — Thu, 29 Jul 2010 16:28:05 GMT

Perhaps someone else could comment on whether there is a performance difference between a document and a server bookmark?

Jonathan

Combining Bookmarks - very slowly.

hdonald — Thu, 29 Jul 2010 16:57:10 GMT

After a bit more testing - comparing the Current Selections before and after the save and recalls - I've fixed the performance problem.

It was the Input Sum field.

It seems that because I had a selection on the Input Sum field being zero, then you have to clear that field in the macro before saving with 'CreateDocBookmark' .

Then it can be used in Set Analysis - otherwise there is a long delay.

I'd prefer to get the macro to save the Input Field with the bookmark ...anyone know how to do that ?