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

[dplr-rn]

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

[sakshikaul]

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 ?

[dplr-rn]

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.

[sakshikaul]

Hi 

can you please explain with a eg?

[Anil_Babu_Samineni]

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

[sakshikaul]

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?

[Anil_Babu_Samineni]

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.

[sakshikaul]

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

[Anil_Babu_Samineni]

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.