Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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!!!
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.
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
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