topic Re: Approach to use 2 Facts as One ? in QlikView

Approach to use 2 Facts as One ?

dmohanty — Thu, 22 Jan 2015 17:12:29 GMT

Hi All,

I have 2 metrics (2 Facts QVDs) which has different data structure and formats. The DATE fields have different definition though in both QVDs and granularity is different as well.

QVD 1 is at Month_Year and Supplier level.

QVD 2 is at Plant, Month_Year and Supplier level.

For example,

QVD 1 has: Month_Year, Supplier_ID, Date_ID, Order Date, Promise Date, Receive Date, KPI1

QVD 2 has: Plant_ID, Month_Year, Supplier_ID, Date_ID, Order Amt, Order Qty, Calendar_ID, KP2.

As a best practice approach, all the Facts to be concatenated into a single table. Looking into my above scenario, could someone please help, Which approach to follow - CONCATENATE (How) or JOIN?

Regards!

Re: Approach to use 2 Facts as One ?

cesaraccardi — Thu, 22 Jan 2015 17:26:07 GMT

Hi,

I think this topic can help you:

http://community.qlik.com/message/454342#454342

Re: Approach to use 2 Facts as One ?

Thu, 22 Jan 2015 17:28:24 GMT

Hi,

A concatenate load will append the data from table 2 to table 1, combining the common fields. If it finds a field which isn't in both tables, it simply loads as blanks in the respective table. This sounds like what you need, this will create 1 main fact table of the two tables combined.

Joining will add columns to your fact table instead of rows.

Re: Approach to use 2 Facts as One ?

hic — Fri, 23 Jan 2015 14:26:12 GMT

I would absolutely concatenate the two fact tables. But you will need Generic Keys to do it properly. Read more here:

Fact Table with Mixed Granularity

Generic keys

HIC