Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Merging sheets together.

Please help people.

I have models:

1. commands.qvw

2. netstat.qvw

3. analysis.qvw

I want to merge these to one .qvw. So far i have created a new qvw with a sheet I have named 'HOME'. I have also added  3 sheets (tabs) namely: 'Commmands'; 'Netstat'; 'Analysis'. Each model consists of 1 sheet.

On the HOME page I have created 3 buttons with the names of 3 tabs.

I have managed to link the buttons on the HOME page to the sheets I have created but how do I link the models to the sheets to merge into 1 model?

Where do i go from here? 

1 Reply
Not applicable

Re: Merging sheets together.

You can only binary a single file in.  In your QVW load script, modify the script to save the exports as qvd files instead of a qvw.  Then in the secord file you can load the qvd files and merge them as needed.  Here is an example.

In Source file

 

Table_Name:

SQL

     SELECT *

     FROM TABLE

;

STORE Table_Name into C:\Data\Table_Name.qvd  (qvd);

In Destination file

Table_Name:

LOAD *

FROM C:\Data\table_Name.qvd;

Table_Name1:

LOAD *

FROM C:\Data\table_Name2.qvd;

Once the load is done, save the file as a qvw.  This will bring all of your data into a single file.

Community Browser