topic Import Tab Sheet in QlikView

Import Tab Sheet

Wed, 30 Sep 2009 20:07:41 GMT

Hello, Can I import tab sheet from other QlikView applications?I do not want copy and past. I want to make something like export...from application1 and import...in application2.Is it possible?

Import Tab Sheet

Wed, 30 Sep 2009 20:55:00 GMT

You can put sections of the load script in a text file, then use those in several applications. From the help...

$(Include = filename )
The include variable specifies a file that contains text that should be included in the script. The entire script can thus be put in a file.

Example:
$(Include=abc.txt);

I am not aware of a way of including a sheet containing tables and charts in another application; that does not mean it can't be done!

Import Tab Sheet

Wed, 30 Sep 2009 23:58:56 GMT

Thanks for the reply!
My language is Portuguese, so do not know if I expressed myself correctly, or did not understand the answer.
I would like to use tabs for an application (qvw) in another, through the export / import, or something.
Today I open an application, open the tab I want, ctrl + a, for all the objects tab. Then I go in another application, layout .. (including tab) ctrl + v. ..
I'd like something more simple, due to the fact that I have to do this with many tabs. In other words, take them from one application to another. I am attaching several qvw in only one.
For macros I already know I can use the export script, and then include in another application (qvw). I can do something as simple as that for tabs?

Import Tab Sheet

Thu, 01 Oct 2009 00:12:20 GMT

You can combine multiple QVWs, but remember, the underlying table structure and relations should be proper after combining. So do as following:

1. Include data from the QVWs (binary) to the target application.

2. Rebuild the target application and see the table relations in the viewer to make sure the relations are proper.

3. Copy/Add new objects to the target application.

For the sheet objects, I cannot see a further shortcut.

-Arun

Import Tab Sheet

Thu, 01 Oct 2009 00:23:55 GMT

Thanks Arun!

All relationships are right, always check. Just as expressions and dimensions.
I do not use binary because I use the QVD these applications, I export / import scripts of them, for the main application.
But from what I understand, the new tab just by inserting and gluing objects. Am I right?

Import Tab Sheet

Thu, 01 Oct 2009 00:28:11 GMT

I don't have a better experience. Lte's wait if someone can gove you a more pleasing answer.

Good luck,

-Arun

Import Tab Sheet

Thu, 01 Oct 2009 00:37:06 GMT

Thank you for your help .. I will wait.

Import Tab Sheet

biester — Thu, 01 Oct 2009 00:46:16 GMT

At least in QV 9 there is an option to Export/Import Document/Sheet Layout (File menu). Perhaps that could help.

Rgds,
Joachim

Import Tab Sheet

rwunderlich — Thu, 01 Oct 2009 04:22:28 GMT

It would be interesting to know why you need to make so many copies. Are the applications duplicates of one another, just with different subsets of data? The typical way to handle this is to use a single application with data reduction.

Some other suggestions:

- You might find it easier to just copy the whole qvw file, delete the objects you don't need and update the script.

- Many of my apps have common objects (like date selections boxes) and common sheets. I use a template.qvw that has my common objects and copy that file when I start a new application.

-Rob

Import Tab Sheet

Thu, 01 Oct 2009 19:59:50 GMT

Thanks
I'll try to use the 9 and then tell what happens.

Import Tab Sheet

Thu, 01 Oct 2009 20:13:53 GMT

Rob ,

Responding to your question, I have different applications, for example imagine a prefecture: qvw to a protocol, a qvw for tribute.. and others say four specific qvw. So I would like to join them in just one, for the user to access only one qvw.