Discussion board where members can get started with QlikView.
how to used one master calendar on another field by using join.
What you want to achieve Can you please explain more?
i have order table which is contain two date field "order date","ship date". i have created master calendar for order date and i want to use same for ship date so how it will be possible by using join.
Please check this
See the links below. I think rwunderlich solution (last link) is the one that can help you.
Using Multiple Dates With Master Calendar
Why You sometimes should Load a Master Table several times
Linking to two or more dates
hello prachi bhagat
u should create a master calender with both dates feilds,
firstly calculate min and max date according to ur order date and shipdate ,then create master from min and max date
then automactically u will get whole dates this is simple way
do it this way for eg i have done this for doj and dol, u can do the same for for orderdate and ship date,
Load *,if(MinDateDOJ < MinDateDOL,MinDateDOJ,MinDateDOL) as MinDate;
Load *,if(MaxDateDOJ > MaxDateDOL,MaxDateDOJ,MaxDateDOL) as MaxDate;
num(Min(Date_joining)) as MinDateDOJ,
num(Max(Date_joining)) as MaxDateDOJ,
num(Min(date_leaving)) as MinDateDOL,
num(Max(date_leaving)) as MaxDateDOL