Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combining multiple sheets from multiple workbooks using different data sources into one

I have two teams that have been working separately to develop different qlikview workbooks. I now need to combine these so I've been looking for the most elegant way to combine two workbooks which use different data sources. I've seen this approach: http://community.qlik.com/message/363474 however, this applies to two workbooks pulling from the same data source.

My plan right now to combine workbook 1 with 2 is to copy everything from 2 into 1 by:

  1. Copying the script
  2. Copying all variables
  3. Copying all sheet objects into new sheets

I'd like to know if a) there is a more elegant way to conduct this process and 2) if this process would serve as a complete import of the second workbook. Thanks in advance.

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hmm, I'm afraid it's not always as simple as that... here are some pointers to think about:

1. Copying the script - be careful when combining the two data models. You really need to ensure that the two sets of entities play well together and don't create any problems with multiplicity, loops etc... This is perhaps one of the most important reasons for not being able to offer such as merge "out of the  box".

2. Copying all the variables - yes, true. In addition to variables, additional entities may need to be checked:

- Groups

- Actions and Triggers

- Macros

- Alternate States

- Custom Number formatting settings

3. Copying the sheet objects:

This is perhaps the most trivial part - Ctrl-A, Ctrl-C to copy, Ctrl-V to paste in the new document. Keep in mind that you may have some conditionally hidden objects. If you use conditional show/hide, all the conditions need to be turned on one by one and the corresponding objects copied individually. Alternatively, you can press Ctrl-Shift-S to toggle "show all" setting. This way, you can copy all the objects at once.

good luck!

Oleg Troyansky

www.masterssummit.com

View solution in original post

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hmm, I'm afraid it's not always as simple as that... here are some pointers to think about:

1. Copying the script - be careful when combining the two data models. You really need to ensure that the two sets of entities play well together and don't create any problems with multiplicity, loops etc... This is perhaps one of the most important reasons for not being able to offer such as merge "out of the  box".

2. Copying all the variables - yes, true. In addition to variables, additional entities may need to be checked:

- Groups

- Actions and Triggers

- Macros

- Alternate States

- Custom Number formatting settings

3. Copying the sheet objects:

This is perhaps the most trivial part - Ctrl-A, Ctrl-C to copy, Ctrl-V to paste in the new document. Keep in mind that you may have some conditionally hidden objects. If you use conditional show/hide, all the conditions need to be turned on one by one and the corresponding objects copied individually. Alternatively, you can press Ctrl-Shift-S to toggle "show all" setting. This way, you can copy all the objects at once.

good luck!

Oleg Troyansky

www.masterssummit.com