topic Re: Master Calendar in QlikView

Master Calendar

Wed, 25 Nov 2020 16:16:04 GMT

Hai Guyz,

Master calendar

I have a Register in which per Month Only one date entry is registered.

So If I have more than decade data wouldn't the master calendar generate all the dates between

mindate and maxdate. It Will be a lot of dates, Will it effect Size or speed of the process.

Thanks

John David

Re: Master Calendar

Anonymous — Thu, 03 Nov 2016 07:49:47 GMT

Hi,

To my knowledge, it should not affect the speed. The performance would be affected by how big the KEY is. But generally, I have found that master calendars do not slow down performance unless badly designed in the first place. I would recommend a master calendar that only has dates from the first time a date was used to only the latest date.

Re: Master Calendar

its_anandrjs — Thu, 03 Nov 2016 08:07:41 GMT

Hi,

It would be not affected by using this dates if you use the QVD of the Master calendar it will be much faster in comparison to the other tables.

Regards,

Anand