topic Re: Create missing days in calendar in QlikView

Create missing days in calendar

anjali0108 — Fri, 13 Oct 2017 15:40:21 GMT

Hi All,

I have a requirement where the client wants to see all the days in calendar irrespective of whether the data is present or no in the files that were shared to us.

I am making day,month and year from the common date that I am forming by using the file names.

Everything is working fine for me. The only requirement is customer wants to see the missing days also in the calendar,

Client is ok if no data comes for that respective selection but all days should come.

Hope this explains my requirement.

Thanks.

Re: Create missing days in calendar

Anil_Babu_Samineni — Fri, 13 Oct 2017 15:44:34 GMT

May be Master Calendar Generation Script

Re: Create missing days in calendar

sunny_talwar — Fri, 13 Oct 2017 15:44:40 GMT

A master calendar script should do this for you

Creating A Master Calendar

Re: Create missing days in calendar

its_anandrjs — Fri, 13 Oct 2017 15:45:03 GMT

You can join your calendar with your transaction table then.

Ex:-

fact:

Load

Comman_Date

From Source;

Left Join(fact)

Calendar:

Load

Comman_Date,

Month,Day,Year

From Source;

Re: Create missing days in calendar

anjali0108 — Fri, 13 Oct 2017 15:54:39 GMT

Thank You All for the quick revert.

I will try the same and revert. Thank You

Re: Create missing days in calendar

its_anandrjs — Fri, 13 Oct 2017 16:12:49 GMT

Find the attached and let me know with this way you can try in your solution.