How to Link same object on diff. sheet.

[#1]

Hi All,

Can anybody tell me how I can use same object on each sheet.

Also let me know what is the use of Cntrl+Alt and Cntrl+Shft.

Thanks,

Abdulhafiz

[#2]

Hi Abdulhafiz.

To use the same object in diferent sheets, you need to keep pressed the CTRL key, while you get selected the object, move to the sheet you want to copy it.

You can find the CTRL + ALT and CTRL + SHIFT functions in the Menu bar.

Hope this help.

Regards

[#3]

Thanks Emmanuel,

For your reply.

How can I select different values for the same object(copied obj) on the different sheet.

I tried unlink object but still the value is selected in both the sheet.

The copy and link is working fine.

But I didnot find information about Cntrl+Shft and cntrl+Alt.

Regards,

Abdulhafiz

[Miguel_Angel_Baeyens]

Hello Adbulhafiz,

Regardless the object is or is not linked, any selection done in your document will affect to the whole document, regardless the sheet the objects are. If tables in your data model are all linked selecting one value in one field will affect all the other tables in the model, this is part of the associative logic of QlikView magic.

You will have to "force" in your expressions to not be affected by the selections done in field X. So for example say you have a Customers table and its information in a sheet and Sales table and information in a different sheet.

Every time you select a Customer in the Customers sheet, the Invoice sheet will show the values corresponding to the current Customer selection.

Hope that makes sense.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica