Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Import a sheet into a exisiting Qvw file

Hi Guys,

I have a qvw app and would like to add/import the sheets that another developer already created. My undersatnding is after the import of the sheet and adding the sql code to the load script it schould all work...column names are all different so...

In the file menu there is an import layout and and Import sheet but both don't work for what I'd like to do...

Any hints much appappreciated...

Thx

L

4 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Ludwig,

I am not quite sure I follow what you are trying to do here, or how far you have got with it so far.

Generally the easiest way to move objects between documents is to open both of them at once do a Select All (Ctrl+A) on the source sheet and copy (Ctrl+C) move to the target sheet and paste them (Ctrl+V).

If the field names are different between the documents you will need to re-point all of these in the objects.

A trick that often works with doing this is to rename all the fields in the target documents load script to match what the field names are in the source document (OldFieldName as NewFieldName). The objects should all then work after a reload. If you then remove the 'as' of each field one at a time and perform a limited load QlikView should update all objects to use the new field name rather than the old.

Hope that helps - please post back more details if I am missing what it is you are trying to do.

Regards,
Steve

Not applicable
Author

Hi Steve,

I think you hit the nail on top...I'll apply the technique you recommended and let you know.

Thx again

Ludwig

Not applicable
Author

Hi Ludwig123, please have in mind that if You are using hidden object, then that object will not copy.

CTRL+A will select all not hidden objects.

As for the metodology i use the same as mentioned 😉 CTRL + A and CTRL + C then CTRL + V.

Best of luck 🙂

Not applicable
Author

Steve,

That does not seem to work. I have two qvw documents and want to have one sheet which is currently in document A.qvw copied to B.qvw...

tried also the file menu....I don't want to repeat all my format work just would like to copy them where I need it...

Any hints?

Thx

Ludwig