topic Detach/Attach not working on server for tables. in QlikView

Detach/Attach not working on server for tables.

Wed, 15 Feb 2012 15:58:32 GMT

Hello

I have an issue with my document when it is on the server.

I have two tables on a sheet and I want to detach them because I want to export them in Excel and any associations are disabled, giving me a snapshot of the data in the tables. On my Qlikview server, I detach the two tables and save the document. When I close and re-open the document, my saved changes (detaching the tables) don't take effect and the tables are attached.

I do the same exercise on my local machine and the detachments on the tables are saved.

Is there something I need to do in my document settings in regards to server options? I am running Qlikview 10 SR1 on my local machine and Qlikview 10 SR1 on the server too. I find this behaviour quite peculiar.

Thanks

Detach/Attach not working on server for tables.

pover — Wed, 15 Feb 2012 20:46:22 GMT

You can't save any changes made to document objects in the QlikView Server environment. You can create your own objects by cloning the document object and modify them as you like. For example, you can clone the 2 tables and then open the properties window and in the general tab enable the option to detach the table. When you close and open your server session, you should still see it as detached.

Karl

Detach/Attach not working on server for tables.

Thu, 16 Feb 2012 09:12:26 GMT

Hello

Thank you for a reply.

I have tried what you have suggested but I still get the same behaviour on the server.

Thanks

Detach/Attach not working on server for tables.

pover — Thu, 16 Feb 2012 17:01:48 GMT

You're right. This could be a bug. In your case you could create a report that uses set analysis to ignore all selections. For example,

sum({1} Sales)

Karl