topic Re: Need help with sheet size in QlikView

Need help with sheet size

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello community, I have the next question...

if there a way to lock the size of the sheet becouse I have this dashboard

that fit perfect, but when i move the slice in the bottom luck like this..

with that blank space, is there a way to make only the Gray square the Size of the page?

Re: Need help with sheet size

Chanty4u — Fri, 23 Feb 2018 12:54:39 GMT

you can reduce the size view tab zoom

Re: Need help with sheet size

jonathandienst — Fri, 23 Feb 2018 13:05:47 GMT

Why don't you set the document background to the shade of gray and do away with the gray background text box?

Re: Need help with sheet size

Peter_Cammaert — Fri, 23 Feb 2018 13:57:49 GMT

Jonathan has a good point.

A QlikView sheet is a virtual area of "unlimited" size (not really, but I just put an object at pixel position 65535,65535 which means that the usable sheet size is probably so extremely large as to be impractical) and there is no way to limit that sheet area to a smaller size.

What will help though is the suggestion that Jonathan made (i.e. color all of the sheet background instead of just a view area) in addition to locking all objects within a predefined sheet area (disable Move/Size in Properties->Layout) so that you won't get scroll bars on the screens with the most common pixel count.

As soon as any object - visible or invisible - moves any of its extremities ouside of the viewport, you will get scroll bars. This is often a good indication of old discarded objects that are still wandering around on your sheets.

Re: Need help with sheet size

Anonymous — Fri, 23 Feb 2018 14:42:26 GMT

thanks that solve all my questions