topic Re: Data for full calendar with weeks in QlikView

Data for full calendar with weeks

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

Hi all

I need a QVD file or some attachment with data for a calendar with weeks.

I don't have a database SQL in my server, so, I need load a calendar with future datas that I can used like a filter with all days for next years.

somebody help-me?

Re: Data for full calendar with weeks

Anil_Babu_Samineni — Wed, 15 Mar 2017 17:17:58 GMT

Yes you can

Load * From Table; // This is your table

And calendar table seems this with dummy data

LOAD Date(MinDate+IterNo()-1) as Date

While MinDate+IterNo()-1 <= MaxDate;
LOAD MakeDate(1986) as MinDate,
MakeDate(2060) as MaxDate
AutoGenerate 1;

Then Simply Concatenate with Calendar date to your fact Table date. Then we have access the year from 1986 to 2060

Re: Data for full calendar with weeks

Anil_Babu_Samineni — Wed, 15 Mar 2017 17:19:48 GMT

Or this using Weeks and full calendar

Load DateField as DateField, Field1, Field2 from DataSource;

Concatenate

tabCalendar:

LOAD *,

Day(Date) as Day,

WeekDay(Date) as WeekDay,

Week(Date) as Week,

WeekName(Date) as WeekName,

Month(Date) as Month,

MonthName(Date) as MonthName,

Dual('Q'&Ceil(Month(Date)/3),Ceil(Month(Date)/3)) as Quarter,

'Q'&Ceil(Month(Date)/3) & '-' & Year(Date) as QuarterYear,

QuarterName(Date) as QuarterName,

Year(Date) as Year,

Day(Date) & '-' & Month(Date) as DayMonth,

'Week'&Ceil(Day(Date)/7) as WeekNum,

WeekYear(Date) as WeekYear;

LOAD Date(MinDate+IterNo()-1) as DateField

While MinDate+IterNo()-1 <= MaxDate;

LOAD MakeDate(1986) as MinDate,

MakeDate(2060) as MaxDate

AutoGenerate 1;

Re: Data for full calendar with weeks

vbarbera — Wed, 15 Mar 2017 17:21:41 GMT

Hello Milton:

You can see this post. It is very similar to what you are looking for.

Calendario Maestro para obtener todos los días transcurridos

Re: Data for full calendar with weeks

vbarbera — Wed, 15 Mar 2017 17:36:23 GMT

If you want to use the code of Anil Babu Samineni, you have to make a small change. You have to change when you type "Date" with "DateField". It is an excellent solution.

Re: Data for full calendar with weeks

rahulpawarb — Wed, 15 Mar 2017 18:29:28 GMT

Hello Milton,

Please refer the sample application along with MasterCalendar.QVD file attached herewith. Let us know if you have any queries.

Regards!

Rahul

Re: Data for full calendar with weeks

Anonymous — Sat, 18 Mar 2017 17:27:22 GMT

thank you Saminemi!

But I'll use the MasterCalendar.QVD, but his answer will be very useful for other tasks!

Re: Data for full calendar with weeks

Anonymous — Sat, 18 Mar 2017 17:29:48 GMT

Thank you, Pawar!

I'll use MasterCalendar.QVD for my application!

Regards,

Milton Nakayama

Re: Data for full calendar with weeks

rahulpawarb — Mon, 20 Mar 2017 04:22:22 GMT

Cheers,

Rahul