Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

prachi91
Contributor

master calendar

hi,

how to used one master calendar on another field by using join.

thank you.

5 Replies
prma7799
Honored Contributor III

Re: master calendar

What you want to achieve Can you please explain more? 

prachi91
Contributor

Re: master calendar

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.

prma7799
Honored Contributor III

Re: master calendar

Please check this

Canonical Date

Highlighted
elizafilip_2014
Contributor II

Re: master calendar

rohitlohani
New Contributor III

Re: master calendar

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;

Load

   num(Min(Date_joining)) as MinDateDOJ,

   num(Max(Date_joining)) as MaxDateDOJ,

   num(Min(date_leaving)) as MinDateDOL,

   num(Max(date_leaving)) as MaxDateDOL


regards

rohit lohani