topic Re: master calendar? in QlikView

master calendar?

Thu, 30 Oct 2014 07:46:43 GMT

'FY' & Right(Year(AddMonths([CreatedOn],-6)),2) & '/' & Right(Year(AddMonths([CreatedOn],6)),2) AS [Financial Year],

pls explain me (AddMonths([CreatedOn],-6)),2 what -6 do here? full expression clearly

Re: master calendar?

sushil353 — Thu, 30 Oct 2014 07:51:26 GMT

Hi,

AddMonths([createdOn],-6) will take you 6 months back..

say if today is month of October-2014 and if I apply above formula then it will return April-2014..

HTH

Sushil

Re: master calendar?

Thu, 30 Oct 2014 07:52:27 GMT

(AddMonths([CreatedOn],-6)),2) what about 2 here

Re: master calendar?

its_anandrjs — Thu, 30 Oct 2014 07:53:07 GMT

Hi,

By AddMonths([CreatedOn],-6)) expression we go back 6 months back it would be like in [CreatedOn] date this function less 6 months and give out put

Ex:- if date is 30/10/2014 it will show 30/4/2014

And in this line Right(Year(AddMonths([CreatedOn],-6)),2) it calculate Year(AddMonths([CreatedOn],-6)) and then from right 2 values that is YY is fetched.

Same is going on the other expression.

Regards

Anand

Re: master calendar?

danieloberbilli — Thu, 30 Oct 2014 07:53:16 GMT

the months are going backwards: not added but back in time (-6 months)

Re: master calendar?

Thu, 30 Oct 2014 07:53:21 GMT

Hi,

If you are looking for Master Calendar.

Follow the below link.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

Re: master calendar?

its_anandrjs — Thu, 30 Oct 2014 07:55:09 GMT

From right 2 values that is YY is fetched.

Regards

Anand

Re: master calendar?

Thu, 30 Oct 2014 07:56:08 GMT

it means 2014 so it is going to fetch 14 only right?

Re: master calendar?

its_anandrjs — Thu, 30 Oct 2014 07:58:27 GMT

Yes right..

Regards

Anand

Re: master calendar?

jagan — Thu, 30 Oct 2014 08:00:04 GMT

Hi Manoj,

Check this

Right(Year(AddMonths([CreatedOn],-6)),2)

- AddMonths([CreatedOn],-6) will give you the date past (subtract) 6 months from created on date,

For example AddMonths(Today(), -6) will give you 4/30/2014

- Year(AddMonths([CreatedOn],-6)) - Year() will give the year for the above date

Right(Date, 2) - will give you the right most characters in the date, ie, 2014

Instead you can simply do this by using

Date(AddMonths([CreatedOn],-6), 'YY')

Hope this helps you.

Regards,

Jagan.