topic Object created on one sheet should be visible on another sheet in QlikView

Object created on one sheet should be visible on another sheet

ashishpalkar — Tue, 01 Sep 2015 18:37:40 GMT

Hi There

I have below requirement ,

I have created Sheet 1 using 10 Objects.

I have created Sheet 2 using 10 Objects.

There are 5 common Objects in both sheet., how can i use the objects in 2nd sheet without recreating it in other sheet?

thanks in advance,

Re: Object created on one sheet should be visible on another sheet

Qrishna — Tue, 01 Sep 2015 18:43:53 GMT

You can copy-paste the object.

if you want the the similar objects behave the same way, then create linked objects.

how to create linked object : QlikTip #26: Introducing Linked Objects in QlikView 10

Re: Object created on one sheet should be visible on another sheet

sunny_talwar — Tue, 01 Sep 2015 18:47:48 GMT

Ctrl C + Ctrl V

Re: Object created on one sheet should be visible on another sheet

ashishpalkar — Tue, 01 Sep 2015 19:30:34 GMT

Hi Krishna / Sunny

I dont want to copy & paste the objects, instead of this can we use existing objects of sheet 1 in sheet 2?

Re: Object created on one sheet should be visible on another sheet

ecolomer — Tue, 01 Sep 2015 19:32:26 GMT

You can use Contenidor with the same object

Re: Object created on one sheet should be visible on another sheet

Peter_Cammaert — Tue, 01 Sep 2015 19:50:00 GMT

Do you want sheets with holes in 'em so that in certain areas you can see through and operate objects on another sheet? Not possible in QV, I'm sorry.

Copies of objects all behave exactly the same if you do not change individual properties. They even light up together. Linked objects will also share almost all properties except for size and position. That way you only have to change the color of one copy to put them all in a different color.

But it all starts with C & P.

Best,

Peter

Re: Object created on one sheet should be visible on another sheet

ecolomer — Wed, 02 Sep 2015 16:23:25 GMT

See this example:

Is that you need??

Re: Object created on one sheet should be visible on another sheet

ashishpalkar — Wed, 02 Sep 2015 16:29:24 GMT

Thanks Enrique, MonthYear is your linked object?

Re: Object created on one sheet should be visible on another sheet

ecolomer — Wed, 02 Sep 2015 16:32:05 GMT

All 3 objects (MothYear, year and Month)

See all sheets, and see list of obbjects in the document