Each Sheet as Document..

[#1]

Hi,

I have a QVW document with 12 sheets.

Now can I convert all those 12 sheets to 12 different documents with same data model??

Is there any simple way to convert rather than building again from scrap?

Regards,

Hemanth Dasari.

[settu_periasamy]

Not sure.. I'm understand correctly or not..

Do you want 12 qvw documents?

May be load your base qvw using binary load and copy your sheets (All objects using Ctrl +A) and paste it..

Or take 12 copies of document and remove your unwanted sheets..

[marcus_sommer]

Why do you want to do this - what's the aim?

- Marcus

[Oleg_Troyansky · Accepted solution]

I'd say - copy the document 12 times and remove unnecessary sheets - this way, all variables, groups, and other objects remain intact.

You could even develop a simple VBScript macro that performs it automatically, to avoid any manual mistakes.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business - the Expert Guide to QlikView and Qlik Sense.

[Mark_Little]

Hi,

Copy the document, rename to the new name. Remove the sheets you don't want?

If not done already, have one document that loads from source and outputs to qvds, then load all documents from the QVDs

Mark

[sathishkumar_go]

Hi,

You can copy the application 12 times manually or

try the below command.

EXECUTE cmd.exe /C COPY /Y "$(v_Document_Name)" "$(v_File_Path)";

-Sathish

[#7]

I developed a document with 12 tabs. Now I though it was not a good design.

Now What I want to do is separate each sheet into a document and maintain links between them so that only one sheet will be in memory. And also whenever someone has to redesign a particular sheet we can give that particular sheet for re-development rather than exposing complete dashboard.

[marcus_sommer]

It's often quite difficult to find the right balance between the number of sheets + sheets-objects and the usability to navigate between them and other goals like the application-size, complexity of the datamodel and the efforts to develop und maintain it and also to predict the kind and amount of using from the users.

And there is no general right or wrong - it will be always depend on various parameters, like your hardware-ressources, update-windows, number and kind of licences and many more.

In your case I'm not sure if you have really advantages by splitting these app into 12 apps which meant probaly that you have 12 times have to load the same datamodel (unless you made the efforts and optimized the datamodel for each app but your question didn't sound in this direction) and you have 12 times more RAM consumption and by using from document CAL's you will need some more.

- Marcus

[Oleg_Troyansky]

I tend to agree with Marcus. In addition to 12-times memory consumption, managing 12 individual, yet similar, documents will likely lead to a maintenance nightmare. Think about all the shared components that could be common among multiple sheets:

- Variables

- Groups

- Bookmarks

- Triggers and Actions

- Expressions

Changing one of them in one of the documents will likely require a similar change in all 12 documents. How many chances do you have to get it wrong?

The convenience of changing one sheet at a time is compelling, but this coin has a flip side that's rather ugly.

cheers,

Oleg Troyansky