topic Re: Independent security on table columns size and table size in QlikView

Independent security on table columns size and table size

justin_morley — Fri, 05 Jul 2013 08:47:17 GMT

Hi,

Is it possible to set the security on the size of columns and the size of a table independently?

If I check "Move/Size Sheet Objects" it affects both at once.

I really want users to be able to resize columns, but not be able to touch the position or size of the table

Thanks,

Justin

Re: Independent security on table columns size and table size

Gysbert_Wassenaar — Fri, 05 Jul 2013 13:49:57 GMT

I can't reproduce this. Unless you mean they should be able to resize not only columns, but the object itself. That's not possible. Users will be able to resize columns in an object, but can't resize the object when you disable Move/Size Sheet Objects.

Re: Independent security on table columns size and table size

justin_morley — Mon, 08 Jul 2013 14:11:00 GMT

Thanks for the reply Gysbert.

This is not what I'm seeing.

If I enable "Move/Size Sheet Objects", it allows the columns to be resized, which is desirable behaviour for us, but it also allows the object to be moved and resized, which is extremely undesirable.

If I disable "Move/Size Sheet Objects", the objects are locked which is good, but the data column widths is also locked which is undesirable, as some data which is too large for the current column appears as hashes.

From what you say, with "Move/Size Sheet Objects" disabled, column resizing should still be allowed. Is there another setting somewhere I'm missing, something on the server for instance?

Thanks,

Justin