Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

koushik_btech20
Contributor

Multiple date for one calender problem(Order date and Ship Date)

Hi,

Please guide me how to handle multiple Fact date in  Common Calender. In the transaction database the fields are ,

OrderID,SalesPersonID,CustomerID,OrderDate,ShipDate,ShipMode,Product.OrderQuantity,UnitPrice,ShippingCost

Anyone have any solution, then please share...

Tags (2)
2 Replies
vikasmahajan
Honored Contributor III

Re: Multiple date for one calender problem(Order date and Ship Date)

Try to implement link table in your project is better approach.

Good Luck

Vikas

Re: Multiple date for one calender problem(Order date and Ship Date)

See this blog post: Why You sometimes should Load a Master Table several times

And this discussion: Tutorial - Using Common Date Dimensions and Shared Calendars


talk is cheap, supply exceeds demand
Community Browser