Combining two data models into one

[sakshikaul]

Hi ALL, I have created a dashboard on audit analysis and now want to combine fact table of audit dashboard into the fact of some other dashboard Following is the scenario :- I have two dashboards For dashboard1(newly created) I have firstly extracted the data from database and stored in qvd for dashboard 1(audit dashboard) then I have applied business logic on stage 2 and then again stored in qvd now I want to combine fact table of audit dashboard into some other fact of already existing dashboard Please help meto resolve the above scenario. Regards Sakshi

[sakshikaul]

Hi

Theses are two separate data models(in picture below) which I have created in single qvw.

2 seperate data models in single qvw1. but now I want when i am working on data model 2 in front end then calender2 should get active and when I am working on data model 1 then csalender 1 should work 

2. I want to connect data model2 with data model1 because i want to apply some feilds like zone,sbu (filters) from data model 1 into data model 2

No how to handle both the things 

Please help

[Anil_Babu_Samineni]

1. but now I want when i am working on data model 2 in front end then calender2 should get active and when I am working on data model 1 then csalender 1 should work

LET vDocPath = DocumentName();
If $(vDocPath) = 'DataModel1.qvw' Then
LOAD * Resident Calendar_Model1;
Else
LOAD * Resident Calendar_Model2;
ELSEIF

2. I want to connect data model2 with data model1 because i want to apply some feilds like zone,sbu (filters) from data model 1 into data model 2

Run same script from scenario-(1) and load Entire model 1 into script

[Brett_Bleess]

Just wanted to add the following Design Blob post at this point, as it seems it may be useful:

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Be sure to mark any posts that helped you resolve issues using the Accept as Solution button so others will know which posts helped you resolve the issues you encountered.

Regards,
Brett