Master calender

[qlikview979]

Hi Experts,

I don't have Date field in source. How can i  create  Master Calender.

Regards,

Mahesh

[MK_QSL]

What field you are having?

[qlikview979]

Hi Manish,

I want to learn about Master Calender . What purpose  we need to use  master calender? what is the use?can you share with Example?

Regards

[muthukumar77]

Hi,

Can you send me sample app?

[sampada0810]

You must be having some id or a key not necessarily in date format. You can use that.

Here's a script to create a master calender.

[bindu_apte · Accepted solution]

Hi Muthukumar,

Hope these thread will help you out.

How to use - Master-Calendar and Date-Values

Creating A Master Calendar

[sampada0810]

In QlikView, many times we need to create a calendar reference object which can be linked to any data set present in QlikView's memory. For example you have a table that captures the sales amount and sales date but does not store the weekday or quarter which corresponds to that date. In such scenario we create a master calendar which will supply the additional date fields like Quarter, Day etc as required by any data set.

[Frank_Hartmann]

have a look at attached file.

hope this helps

[migueldelval]

Hi Mahesh,

Try this

How to create a Calendar

Regards

Miguel del Valle

[MK_QSL]

In that case, you will find 100s of blogs and questions related to master calendar, fiscal calendar, canonical calendar etc.

try to spend some time on community search and let us know if you don't know some specific blog or question/answer.