Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Create missing days in calendar

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.

5 Replies
Highlighted

Re: Create missing days in calendar

May be Master Calendar Generation Script

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Re: Create missing days in calendar

A master calendar script should do this for you

Creating A Master Calendar

Highlighted

Re: Create missing days in calendar

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;

Highlighted
Partner
Partner

Re: Create missing days in calendar

Thank You All for the quick revert.

I will try the same and revert. Thank You

Highlighted

Re: Create missing days in calendar

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