topic Re: Position objects on sheets in QlikView

Position objects on sheets

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

Hello,

I have a QVW file with 10 tabs. I want to copy an object from tab1 and place this same object at the same position on the sheet

in the other 9 tabs (tab2 thru tab10). Is this possible and if so, how do I do this?

Thanks

Re: Position objects on sheets

Anonymous — Thu, 25 Feb 2016 19:19:50 GMT

When you copy and paste object from one to sheet to another sheet it will by default be pasted in the same position.

Re: Position objects on sheets

Anonymous — Thu, 25 Feb 2016 19:30:58 GMT

I must have not done it correctly. It's working now.

Slightly different question. I have an object that sits in 10 tabs. I want resize this object and have it appears

consistently (same coordinates), Is there a quick way to do this for all 10 tabs or I have to go to the "Caption" page

for each tab and adjust the coordinates there?

Re: Position objects on sheets

Clever_Anjos — Thu, 25 Feb 2016 19:35:12 GMT

Don´t paste them, but "Past Sheet Object as a Link"

Them Right-Click / Linked Objects / Adjust Position of Linked Objects

This will keep them at same position and with same size

Re: Position objects on sheets

Anonymous — Thu, 25 Feb 2016 19:35:19 GMT

I am not aware of a quick way, but rather going to the caption tab - how about deleting the object from the 9 tabs, re-size the object on the first tab and copy / paste it back the 9 tabs.

Also you can paste as a link to the object, although this won't help with re-sizing,

Re: Position objects on sheets

Anonymous — Thu, 25 Feb 2016 19:40:31 GMT

Just to clarify... This object contains different data for each of the tabs. It just happens to be located at the same position on each sheet. Sounds like I would need to go to the caption page and make the change there, right?

Looking at the menu in the screenshot, "Paste Sheet Object as a Link" if all of my 10 tabs are using the same chart, correct?

Re: Position objects on sheets

Clever_Anjos — Thu, 25 Feb 2016 19:53:39 GMT

"This object contains different data for each of the tabs", so linking is not an option, unless you create your expressions like

IF(GetActiveSheetId()='SH01', sum(Expression1))

So the best solution would be going to Caption Tab of each object and ajusting X,Y, Height and Width

Re: Position objects on sheets

Clever_Anjos — Thu, 25 Feb 2016 20:09:15 GMT

Another workaround would be a macro that sets your objects position

Re: Position objects on sheets

Anonymous — Thu, 25 Feb 2016 20:12:45 GMT

Thanks for everyone's help and your quick replies. I just resized them all manually.

Yes, some day, I will get to the level of QV experience to be able to write Macros.

Re: Position objects on sheets

Anonymous — Thu, 25 Feb 2016 20:15:15 GMT

Could well be quicker to do it the "slow" way,say 1 minute per object, 10 objects - so sorted in 10 minutes.

Sometimes sorting a quick way takes a lot longer than just doing it.

Re: Position objects on sheets

Clever_Anjos — Thu, 25 Feb 2016 20:19:02 GMT

But if you have to change the position several times, that 10 minutes could be a pain

Re: Position objects on sheets

Anonymous — Thu, 25 Feb 2016 20:22:21 GMT

Bill,

I got your point. 10 minutes was nothing for me to resize 10 tabs. If I could do it in 2 steps vs. 5 steps, I want the

2 step approach. In addition, since I'm new to QV development, I want to know the efficient approach in case if I need to repeat this exercise again. Just looking for efficiency.

Re: Position objects on sheets

Anonymous — Thu, 25 Feb 2016 20:24:24 GMT

You just beat me by 3 seconds.

Re: Position objects on sheets

Clever_Anjos — Thu, 25 Feb 2016 20:30:48 GMT

Preparing a macro here, hold on for a few minutes

Re: Position objects on sheets

Clever_Anjos — Thu, 25 Feb 2016 21:01:02 GMT

PFA attached an example

Note: not optimized (I could use subroutines, etc)

Re: Position objects on sheets

Anonymous — Fri, 26 Feb 2016 13:33:01 GMT

Hi, thank you for the sample. I will check it out and let you know.