topic Regarding Data model in QlikView

Regarding Data model

Tue, 07 Jul 2015 03:06:03 GMT

Hi All

I have following Data model

able

Here i have two fact tabels One is orders and other one is orderDetails

so can u pls advise me to make them single table ..what i have to do??

i did concatination of both tables but pbm is

when i m trying see quantityOrderd per customer number data is not cmg(with out concat data is cmg crctly)

can anyone pls help me

Re: Regarding Data model

jagan — Tue, 07 Jul 2015 03:16:06 GMT

Hi Narendra,

You should not concat this two tables, you can maintain it separately or you can join the tables based on the OrderNumber.

Orders:

LOAD

FROM OrdersDataSource;

Left Join(Orders)

LOAD

FROM OrderDetailsDataSource;

Regards,

Jagan.

Re: Regarding Data model

Tue, 07 Jul 2015 03:22:22 GMT

Hi Jagan

Orders table is Having 1400 rows

& OrderDetails is having 2996 rows

so if i do left join data will get duplicate ryt?? that time if i do any sum(quantityOrderd) will it give crct ans??

i attached My QVW file also

Re: Regarding Data model

jagan — Tue, 07 Jul 2015 03:28:13 GMT

Hi,

You have QuantityOrdered field in OrderDetails table, so there should not be any issue. Also make that OrderNumber is unique in Orders table, if not then don't join this tables otherwise you will get duplicate rows.

My suggestion is not to join. In your attachment check there are lot of OrderNumber s missing for many rows almost 25% of rows do not have OrderNumber.

Regards,

jagan.

Re: Regarding Data model

Tue, 07 Jul 2015 04:00:48 GMT

Check below links:

May help you.

Fact Table with Mixed Granularity

Data Model best Pratice

Data model issue - Merging 2 fact tables into 1