Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Create Calendar in two fields dates

Hello There,

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

A_DateB_Date
2019070120190702
2019070120190731
2019080120190830
2019100120191021

 

I hope you understand what im saying.

Best Regards,

Bing

Labels (1)
3 Replies
Highlighted
Creator II
Creator II

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.

Highlighted
Creator II
Creator II

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;

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.