topic Re: How to connect master calendar when DB table having multiple Date fields. in QlikView

How to connect master calendar when DB table having multiple Date fields.

Anonymous — Thu, 20 Jul 2017 12:47:56 GMT

Hi All,

How to connect master calendar when DB table having multiple Date fields.

EX: DB Table

Booking_date

Conform_date

Cancel_date

Master Calendar

Date

Year

Month

Quarter

Week

FY_YEAR

FY_Quarter

Year_Month

Thanks,

Krishna.

Kushal_Chawda — Thu, 20 Jul 2017 12:50:13 GMT

see this

Kushal_Chawda — Thu, 20 Jul 2017 12:50:56 GMT

or this

arvind_patil — Thu, 20 Jul 2017 12:53:54 GMT

Hi Krishna,

You need to first combine all the dates into a table with the help of link table or Concatenate

and then master calender apply.

Thanks,

Arvind Patil

Anil_Babu_Samineni — Thu, 20 Jul 2017 13:00:01 GMT

Or this?

effinty2112 — Thu, 20 Jul 2017 13:03:19 GMT

Hi Krishna,

Multiple calendars might work for you. My main apps have three calendars for the three types of dates I use.