topic Re: master calendar in QlikView

master calendar

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi,

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

thank you.

Re: master calendar

prma7799 — Wed, 01 Nov 2017 05:33:55 GMT

What you want to achieve Can you please explain more?

Re: master calendar

Anonymous — Wed, 01 Nov 2017 05:40:08 GMT

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.

Re: master calendar

prma7799 — Wed, 01 Nov 2017 05:53:47 GMT

Please check this

Canonical Date

Re: master calendar

ElizaF — Wed, 01 Nov 2017 05:56:09 GMT

Hi,

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

Re: master calendar

Anonymous — Wed, 01 Nov 2017 06:02:20 GMT

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