topic Re: AddYears in set analysis in QlikView

AddYears in set analysis

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

Hi All

I have below expression where I want to subtract a year from todays date. However, it seems like the expression doesn't evaluate.

Can anyone help, I guess as usual it's something smaller detail I'm missing

Sum({$<CAL_YEAR = {$(=only(CAL_YEAR)-1)}, CAL_MONTH = {$(=Num(Max(CAL_MONTH), '00'))}, BOOKING_DATE = {"<=$(=AddYears(=date(Today(),'dd-MM-yyyy'))-1)"} >} New_NET)

Regards

Stefan

Re: AddYears in set analysis

Anil_Babu_Samineni — Tue, 08 Aug 2017 11:49:17 GMT

May be remove = sign and Try this?

BOOKING_DATE = {"<=$(=AddYears(date(Today(),'dd-MM-yyyy'), -1))"}

Re: AddYears in set analysis

PrashantSangle — Tue, 08 Aug 2017 11:53:06 GMT

BOOKING_DATE={"<=$(=Date(addYears(Today(),-1),'DD-MM-YYYY')"},

Regards,

Re: AddYears in set analysis

sunny_talwar — Tue, 08 Aug 2017 11:54:41 GMT

May be this

Sum({$<CAL_YEAR = {$(=only(CAL_YEAR)-1)}, CAL_MONTH = {$(=Num(Max(CAL_MONTH), '00'))}, BOOKING_DATE = {"<=$(=Date(AddYears(Today(), -1), 'DD-MM-YYYY'))"}>} New_NET)

Re: AddYears in set analysis

sunny_talwar — Tue, 08 Aug 2017 11:57:06 GMT

I believe you missed a closing parenthesis

BOOKING_DATE={"<=$(=Date(addYears(Today(),-1),'DD-MM-YYYY'))"},

Re: AddYears in set analysis

PrashantSangle — Tue, 08 Aug 2017 12:01:35 GMT

thanks..

Re: AddYears in set analysis

Anonymous — Tue, 08 Aug 2017 12:07:47 GMT

That was easy!!!

Thanks so much. I keep learning