Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rido1421
Contributor II

Convert fiscal Yearmonth to Calendar YearMonth

Hi There

Please can you assist me with a method to convert Fiscal YearMonth to Calendar YearMonth

The Fiscal Year starts in October

Much Appreciated

Regards,

1 Solution

Accepted Solutions
Employee
Employee

Re: Convert fiscal Yearmonth to Calendar YearMonth

CalendarDate=AddMonths(FiscalDate,-3)

3 Replies
rido1421
Contributor II

Re: Convert fiscal Yearmonth to Calendar YearMonth

I have a sales model and need to link the budgets to it, in the budgets table I have the Fiscal Date  and need to link to the sales Fact, I cannot link on the Fiscal Date as this causes other complications, I need to link using the Calendar Date but I need to create this in my budget table from the Fiscal Date...

Fiscal Date= 20150101.

Calendar Date=20141001.

Any Suggestions will be appreciated

Employee
Employee

Re: Convert fiscal Yearmonth to Calendar YearMonth

CalendarDate=AddMonths(FiscalDate,-3)

MVP
MVP

Re: Convert fiscal Yearmonth to Calendar YearMonth

Hi,

Subtracting 3 month from your Fiscal date gives you the Calendar Date?  If so you can do this by using AddMonths()

LOAD

*,

AddMonths(FiscalDate, -3) AS CalendarDate

FROM DataSource

Hope this helps you.

Regards,

Jagan.

Community Browser