topic Re: Create Calendar in two fields dates in QlikView

Create Calendar in two fields dates

bsbernabe — Sat, 16 Nov 2024 01:10:34 GMT

Hello There,

How to make a calendar in two fields join dates to get the month and year?

A_Date	B_Date
20190701	20190702
20190701	20190731
20190801	20190830
20191001	20191021

I hope you understand what im saying.

Best Regards,

Bing

Re: Create Calendar in two fields dates

mfarsln — Thu, 27 Feb 2020 09:04:35 GMT

Hi,

Those dates are something like start and end dates and you want to create master calendar with one date field which is formed by merging those two dates. This is what i understand.

If this is the case and if months and years will be same for two dates, you can create new field using

MonthStart(A_Date) as MasterDate

And then on your master calendar use only the MasterDate column.

Re: Create Calendar in two fields dates

Surya — Thu, 27 Feb 2020 09:27:11 GMT

Hello, In This we require one primary key

Here Sno is pK

TEMP:

Load Sno,

Date((A_DATE) + IterNo() -1 ,'DD-MM-YYYY') AS TEMPDATE

Resident [Bank INM] While IterNo() <= (B_DATE - A_DATE +1);

CALENDER:

LOAD DATE(TEMPDATE,'DD-MM-YYYY') AS DATE,

Sno,

MONTH(TEMPDATE) AS MONTH,

YEAR(TEMPDATE) AS YEAR Resident TEMP;

DROP TABLE TEMP;

Re: Create Calendar in two fields dates

Brett_Bleess — Tue, 31 Mar 2020 21:28:42 GMT

Only thing of which I can think is the following Design Blog to maybe shed some further light, I am including the base URL for the area below that in case you wish to search further on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett