topic Re: Combining two data models into one in QlikView

Combining two data models into one

sakshikaul — Fri, 30 Aug 2019 16:38:37 GMT

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

Re: Combining two data models into one

dplr-rn — Fri, 30 Aug 2019 19:41:13 GMT

Not compltely clear on your question but usual approach is You can either concatenate fact tables or you can create Link table based on the scenarios.
below is a technical brief on combining fact tables

https://community.qlik.com/t5/Qlik-Design-Blog/Fact-Table-with-Mixed-Granularity/ba-p/1468238

Re: Combining two data models into one

sakshikaul — Sat, 31 Aug 2019 04:04:46 GMT

Hi Thanks for your reply. I am having following data model after I have concatenated new fact into already existing fact. I am getting duplicate keys so, I want to know do I have to make a composite key for the same ?

Re: Combining two data models into one

dplr-rn — Sat, 31 Aug 2019 09:29:03 GMT

If you are concatenating fact tables you should create a new column e g. Facttype. Then you refer to that in set analysis

E.g.

Re: Combining two data models into one

sakshikaul — Sat, 31 Aug 2019 13:46:42 GMT

can you please explain with a eg?

Re: Combining two data models into one

Anil_Babu_Samineni — Sat, 31 Aug 2019 14:51:57 GMT

I may suggest load old QVW to new qvw using binary load.

Re: Combining two data models into one

sakshikaul — Sat, 31 Aug 2019 15:19:40 GMT

after I have applied binary load I am getting the following result, Now how to handle the same ?

Both the data models have calendar so now how to manage these calender?

Re: Combining two data models into one

Anil_Babu_Samineni — Sat, 31 Aug 2019 15:29:25 GMT

Drop the calendar in Old qvw and use same date field from old and new then create Calendar in new qvw for latest date field.

Re: Combining two data models into one

sakshikaul — Sat, 31 Aug 2019 15:43:49 GMT

Hi date field in new calender is diff and date field in old calendar is different. Now how to deal with that?

Re: Combining two data models into one

Anil_Babu_Samineni — Sat, 31 Aug 2019 16:06:07 GMT

If those date fields are different If there is any Primary key which can read the all clubbed rows.

Old_Fact:

Load Old_DF as DateField Resident Fact1;

Concatenate(Old_Fact)

Load New_DF as DateField Resident Fact2;

All other dimension table are follows. Then, Create master calendar based on DateField which is same from all fact tables.

Re: Combining two data models into one

sakshikaul — Mon, 02 Sep 2019 08:40:00 GMT

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

Re: Combining two data models into one

Anil_Babu_Samineni — Mon, 02 Sep 2019 11:26:34 GMT

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

Re: Combining two data models into one

Brett_Bleess — Tue, 10 Sep 2019 16:34:42 GMT

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