topic Re: Date Calculations in QlikView

Date Calculations

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying calculate dates 6 months backward in one expression and one month backward in another expression based on selected variables which are month and year.

The below expressions works fine for any selected month and year above from July to December. When i select any months between Jan and June i am not getting any values.

Think the issue is with the year as it is going to year before, i am not sure how to resolve it, any thoughts?

expression 1: MakeDate(($(vYear)),$(vMonth)-6,01)

expression 2: MonthEnd(MakeDate($(vYear),$(vMonth)-1,01))

jagan‌

Regards,

Karthik

Re: Date Calculations

Anonymous — Wed, 02 Mar 2016 18:34:47 GMT

Hi Try it.

expression 1: Addmonths(MakeDate(($(vYear)),$(vMonth),01),-6)

expression 2: Addmonths(MonthEnd(MakeDate($(vYear),$(vMonth),01)),-1)

Regards

Re: Date Calculations

jagan — Thu, 03 Mar 2016 01:03:55 GMT

Hi,

Try like this, if you are using this in Load script $ is required otherwise no need of $.

expression 1: AddMonhs(MakeDate(vYear), vMonth), -6) // No need of

expression 2: MonthEnd(MakeDate(vYear, vMonth), -1)

Hope this helps you.

Regards,

jagan.

Re: Date Calculations

Thu, 03 Mar 2016 17:53:08 GMT

Thank You.

Re: Date Calculations

Thu, 03 Mar 2016 17:53:31 GMT

Thank you.

Re: Date Calculations

jagan — Fri, 04 Mar 2016 00:46:34 GMT

Hi Karthik,

Did you got the answer? If you get the answer please close this thread by giving Correct and Helpful answers to the post which helps you in getting the answer.

Regards,

Jagan.

Re: Date Calculations

Fri, 04 Mar 2016 08:31:38 GMT

Hi Jagan Garu,

Yes it worked, i am able to mark it as helpful under actions but i cant see any correct answer button?

Regards,

Karthik.

Re: Date Calculations

jagan — Fri, 04 Mar 2016 08:56:37 GMT

HI Karthik,

Goto this link and try

Date Calculations