topic Re: YearToDATE in QlikView

YearToDATE

fcecconi — Tue, 19 Jan 2016 21:18:34 GMT

I am trying to create some flags in my master calendar, but I am having some issues when I have to hard code the end date.

I am hard coding my end date to be (this will be set to Today() when I go live)

Let vEndDate=Floor(MakeDate(2015,12,31));

Then I need to set a CYTD and PYTD flag. Here is the code I am using

-Year2Date(Datum) As CYTD_Flag,

-Year2Date(Datum, -1) As PYTD_Flag,

I am trying to use this new code, but the flag is not being set

-YeartoDate(Datum ,0 ,0 ,$(vEndDate) ) As CYTD_Flag,

What am I doing wrong?

thanks

Re: YearToDATE

sunny_talwar — Tue, 19 Jan 2016 21:23:48 GMT

Not sure but think may be part of the problem. You are giving third argument a value of 0. Look here in help section that it needs to be between 1 and 12 (QlikView ‒ yeartodate - script and chart function)

Re: YearToDATE

fcecconi — Fri, 22 Jan 2016 20:33:26 GMT

I made my change to this: -YeartoDate(Datum,0,1,$(vEndDate)) as CYTD_FLAG,

Thanks Sunny!

Re: YearToDATE

sunny_talwar — Fri, 22 Jan 2016 20:34:10 GMT

No problem at all