topic Moving Columns and saving changes in QlikView

Moving Columns and saving changes

ivandrago — Tue, 12 Oct 2010 15:55:47 GMT

Hi,

Is it possible for a user to move columns around on a table for their own specific order and save this information, so when they open the document again they are in the order they want it to be?

Thanks

Moving Columns and saving changes

ivandrago — Tue, 12 Oct 2010 19:41:13 GMT

I thought a bookmark would have done this but does not seem to keep the columns in order

Moving Columns and saving changes

Anonymous — Tue, 12 Oct 2010 22:09:00 GMT

I would have thought that the "Include Layout State" would have kept the order. It might be a bug or Working as designed, but I would let Support know.

Moving Columns and saving changes

johnw — Tue, 12 Oct 2010 22:19:32 GMT

I don't think this is a very good answer, but they can clone the table as a user object, and then change it as much as they want.

Moving Columns and saving changes

ivandrago — Tue, 12 Oct 2010 23:29:40 GMT

Would they be able to delet the original table? Or would that always show or overlap?

Moving Columns and saving changes

johnw — Tue, 12 Oct 2010 23:35:04 GMT

No, they can't do anything with the real objects, including remove them. If their chart is the same size in the same place, they could set the layer to be above the other chart, and they'll never see the old one. There might also be a way using the show condition for the chart they're replacing. Not particularly friendly, but you could have a button to hide it. Or maybe give them a special tab to make their own tables on, and they can put their custom stuff there. Not sure.

Moving Columns and saving changes

ivandrago — Tue, 12 Oct 2010 23:53:16 GMT

Ok I'll try that. So what does "Include Layout State" do? I thought it would do what I am after?

Moving Columns and saving changes

Wed, 13 Oct 2010 00:00:08 GMT

According to the "QlikView Help", this option should recall the sheet where the bookmark was created and store the state of all the objects within that sheet, for example, cyclic dimension postion or expanded dimension in a pivot table.

Regards

Moving Columns and saving changes

johnw — Wed, 13 Oct 2010 00:01:33 GMT


IvanDrago wrote:So what does "Include Layout State" do? I thought it would do what I am after?

I don't use bookmarks much, so this is just a frustrated user opinion instead of some expert analysis. As far as I can tell, what "Include Layout State" does is "never ever what I want it to do".

Moving Columns and saving changes

Wed, 13 Oct 2010 09:23:51 GMT

Not really a technical answer but this is the approach we took.

When we first encountered this problem the solution we took was to include a page called "scrapbook" on every application we released where the user had full access writes (not locked down on the server same as every other page), the user can then clone the information required move it to the scrapbook page and change it as much as they want. Since this is done through the server it is only saved on their scrapbook for next time they open it.

The most important thing we found was to stress to the users that if they change the chart the information contained becomes their responsibility and not that of the development department otherwise you will be running round everywhere validating peoples charts.

Moving Columns and saving changes

schivet — Fri, 21 Jan 2011 13:21:47 GMT

Hello,

I have also bad experience with Bookmark in Pivot table when using "Cycle". The layout in this case is not saved properly (wrong collum order).

Stéphane

Re: Moving Columns and saving changes

Fri, 25 Sep 2015 14:46:40 GMT

I really wish there was a better solution to moving and saving columns besides copying/cloning the table. I would think saving document layout state in bookmarks would work. Any idea if this will be fixed in future versions in QlikView? Or did anyone else find a better solution?