Star Schema How to Join

[poooja]

Hi Qliks,

Need an help to build Star Schema

Order table has orderdate, customer num, cust name, itemnumber, order num, ordered qty.
Shipped table has shipped date, order date, order num, item num,item description, shipped qty, cust num, cust name.

 How to join them to get :

1. ordered qty vs shipped qty by item description
2. Weekly monthly ordered qty vs shipped qty

Any idea is appreciated.

Thanks!

Pooja

[qliksus]

Hi ,

Yes right , as you need a common dates for representing both the order and shipment