topic Calendar Year in QlikView

Calendar Year

kash04kk — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I'm making the year as follows:

set vNoYears = ($(vE) - $(vS))/(365/1) + 1;

Valuation_Year:

Load

addmonths($(vS),(iterno()-1)*12) as Valuation_Year

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

Here vS is '31-Dec-2011' and vE is '30-Sep-2017'. These are already loaded on the previous sheets. This formula works but shows values like this:

Valuation_Year

31-Dec-2011

31-Dec-2012

31-Dec-2013

31-Dec-2014

31-Dec-2015

31-Dec-2016

I want it to show 30-Sep-2017 also. Any suggestions, please??

its_anandrjs — Wed, 06 Dec 2017 14:01:23 GMT

Your date format is correct can you check this.

sunny_talwar — Wed, 06 Dec 2017 14:02:55 GMT

May be try this

SET vNoYears = ($(vE) - $(vS))/(365/1) + 1;

Valuation_Year:

Load RangeMin(Addmonths($(vS),(iterno()-1)*12), $(vE)) as Valuation_Year

AutoGenerate 1

While IterNo() <= $(vNoYears) + 1;

its_anandrjs — Wed, 06 Dec 2017 14:12:09 GMT

What is your correct values?

kash04kk — Thu, 07 Dec 2017 08:50:26 GMT

Hey Sunny. This worked. Thanks a lot!