topic Re: Combine two QVW Documents in QlikView

Combine two QVW Documents

upaliwije — Wed, 02 Jul 2014 06:20:34 GMT

I have two documents as follows in two different data models

1 Sales Data

2 Profitability Data

in both these document Branch is the common field apart from various other fileds

Now I want to have a combined QVW documents where I want to have following Fields

Branch Sales Profitability

Is there a possibility of doing above ? If so What approach should I take

Thanks in Advance

Re: Combine two QVW Documents

its_anandrjs — Wed, 02 Jul 2014 06:30:54 GMT

Create the link table in between this two data models Sales and Profitability and as you say you have common filed Branch. If there is good relation between the Branch,Sales and Profitability then connect it with the Branch field.

Hope this helps

Re: Combine two QVW Documents

Anonymous — Wed, 02 Jul 2014 06:32:31 GMT

Hi,

First prepare a qvw for sales data and save it.

then create another sheet for profitability data and binary load the first one.

U can find a link between the two.

HTH

Ravi N.

Re: Combine two QVW Documents

sureshbaabu — Wed, 02 Jul 2014 06:50:51 GMT

Hello,

You can use binary load for read data from another QVD and link happens automatically based of common column names.

Please follow the steps below if you are not aware of the syntax for Binary load

1) 1) Create a QVW for Sales data (sales_data.qvw)

2) 2) Go to the script page -> Choose ‘Data’ tab on your left bottom->select ‘Qlikview file’->select the Profitability_data.qvw report.

3) 3) Reload the sales_data.qvw and check the data model

Hope this helps!!!

Re: Combine two QVW Documents

Anonymous — Wed, 02 Jul 2014 06:58:57 GMT

Will binary load reload the .qvw file which is in the other .qvw file? I think it just loads the data that it has into the new .qvw. I think it doesn't reload along with the host .qvw file..Any ideas? Considering this, I asked him to use .bat file.

Re: Combine two QVW Documents

sureshbaabu — Wed, 02 Jul 2014 07:26:25 GMT

you are right!!! we cant reload the qlikview, that is read using the Binary load.

But, we can also check if we could do it thro macors. (I havent tried this)

please check - http://community.qlik.com/thread/68769

Thanks

Re: Combine two QVW Documents

VishalWaghole — Wed, 02 Jul 2014 07:44:30 GMT

Hi upali,

You can do this by merging both Datamodel in single QVW application.

Use link table to connect this two data models,

your linking is based on BRANCH which is same field in both side.

Hope you understand logic.

- Regards,

Vishal Waghoel