Autogenerate Quarters and Months

kash04kk — Wed, 08 Feb 2017 13:57:14 GMT

Hi All,

I'm using the following script to make quarters:

set vStartDate = date(date#('31-Dec-2009','DD-MMM-YYYY'));

set vEndDate = date(date#('31-Dec-2015','DD-MMM-YYYY'));

set vNoQuarters = ($(vEndDate) - $(vStartDate))/(365/4) + 1;

Valuation_Quarter:

Load

addmonths($(vStartDate),(iterno()-1)*3) as Valuation_Quarter

autogenerate 1 while iterno()<= $(vNoQuarters);

This works. I want to make months in a similar manner like this:

set vStartDate = date(date#('31-Dec-2009','DD-MMM-YYYY'));

set vEndDate = date(date#('31-Dec-2015','DD-MMM-YYYY'));

set vNoQuarters = ($(vEndDate) - $(vStartDate))/(365/4) + 1;

set vNoMonths = year($(vEndDate))*12 - year($(vStartDate))*12 + month($(vEndDate)) - month($(vStartDate)) + 1;

Valuation_Quarter:

Load

addmonths($(vStartDate),(iterno()-1)*3) as Valuation_Quarter

autogenerate 1 while iterno()<= $(vNoQuarters);

Valuation_Months:

Load

addmonths($(vStartDate),(iterno()-1)*1) as Valuation_Months

autogenerate 1 while iterno()<= $(vNoMonths);

By using this, I'm getting "Out of Object Memory" error. Any solution for this? Or if you can suggest any easier alternative to autogenerate quarters and months, please do.

Thanks and Regards,

Kashif

Re: Autogenerate Quarters and Months

marcus_sommer — Wed, 08 Feb 2017 14:09:46 GMT

I think it would be easier to create month and quarters within a master-calendar. Here you will find many informations about How to use - Master-Calendar and Date-Values.

- Marcus

topic Autogenerate Quarters and Months in QlikView

Autogenerate Quarters and Months

Re: Autogenerate Quarters and Months