I would like to add in a master calendar in my qlikview app.
In my orders table - there are OrderDate, Year, and other fields.
In my sales_target tabble there are Month, Year and other fields.
I dont know how to create a master calendar with such fields...
With such fields? You mean with multiple dates in your app? May be see this
How to Create a Master Calendar with 3 Fact Tables
I had a similar scenario. check out the link above in addition to sunny's suggestion.
Retrieving data ...