topic Re: Master calendar script required to connect to script in QlikView

Master calendar script required to connect to script

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

Please share the master calendar script required and what modifications to be made in my original script to connect to the master calendar.

I have date, month and year fields in my original script. How to connect this to the master calendar.

Please share master calendar script and the adjustments to be made to link it to the original script to give correct results.

Thank ypu

Re: Master calendar script required to connect to script

Anil_Babu_Samineni — Fri, 17 Nov 2017 03:48:21 GMT

Master Calendar Generation Script

In that, InvoiceDate is your date field.

In that, Calendar your wish to create from calendar dates or that's fine with existing one of Month and Year.

Re: Master calendar script required to connect to script

luismadriz — Fri, 17 Nov 2017 04:08:44 GMT

Hi,

I created this process with parameters that created a master calendar for any date field you want and other stuff to facilitate time analysis. Let me know if you need help using it,

My 2 cents on Time Analysis

Cheers,

Luis

Re: Master calendar script required to connect to script

sumanta12 — Fri, 17 Nov 2017 07:46:43 GMT

TABLE:

LOAD

Product,

Date,

Sales

FROM

(ooxml, embedded labels, table is Sheet1);

MINMAX:

LOAD

MIN(Date) AS MIN_DATE,

MAX(Date) AS MAX_DATE

RESIDENT TABLE;

LET vMin=PEEK('MIN_DATE',0,'MINMAX');

LET vMax=PEEK('MAX_DATE',0,'MINMAX');

DROP TABLE MINMAX;

TMP_CAL:

LOAD

DATE($(vMin)+ROWNO()+1) AS D

AUTOGENERATE $(vMax)-$(vMin)+1;

CALENDAR:

LOAD

DATE(D) AS Date,

DAY(D) AS Day,

MONTH(D) AS Month,

YEAR(D) AS Year,

MONTH(D)&'-'&YEAR(D) AS Month_Year,

'Q'&Num(ceil(month(D)/3)) AS Quarter,

QUARTERNAME(D) AS Quarter_Name,

'W'&right(WeekName(D,0,-4), 2) AS Week,

WEEKSTART(D,0,-4) AS Week_Start_Date,

WEEKEND(D,0,-4) AS Week_End_Date,

MONTHSTART(D) AS Month_Start_Date,

MONTHEND(D) AS Month_End_Date,

QUARTERSTART(D) AS Quarter_Start_Date,

QUARTERSTART(D) AS Quarter_End_Date,

YEARSTART(D) AS Year_Start_Date,

YEAREND(D) AS Year_End_Date

RESIDENT TMP_CAL;

DROP TABLE TMP_CAL;

Re: Master calendar script required to connect to script

luismadriz — Tue, 21 Nov 2017 07:12:58 GMT

Hi,

Just wondering to know how did you go,

Cheers

Luis

When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others