Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

shanmurugesh
Not applicable

how to calculate financial year start date from given date in qlikview

Dear all,

I wabt to calculate financial year start date from given date in qlikview ..can anyone pls tell how to calculate?

Thanks Regards,

Murugesan.N

1 Solution

Accepted Solutions
swuehl
Not applicable

how to calculate financial year start date from given date in qlikview

What is the definition of your fiscal year? When does it start?

You could probably use Yearstart() or Yearname() functions or similar date functions to assign the fiscal year to your date, add a field to your calendar table:

YearStart( date [, shift = 0 [, first_month_of_year = 1]])

or

YearName(date [, shift = 0 [, first_month_of_year = 1]] )

LOAD

...

Date,

Year(Yearstart(Date, 0, 4)) as FiscalYear,

From ...;

OR use

Yearname(Date, 0, 4) as FiscalYear,

With a different formatting (2011-2012) then before (2011).

In both examples, I used April (first_month_of_year=4) as start of the fiscal year.

Hope this helps,

Stefan

3 Replies
swuehl
Not applicable

how to calculate financial year start date from given date in qlikview

What is the definition of your fiscal year? When does it start?

You could probably use Yearstart() or Yearname() functions or similar date functions to assign the fiscal year to your date, add a field to your calendar table:

YearStart( date [, shift = 0 [, first_month_of_year = 1]])

or

YearName(date [, shift = 0 [, first_month_of_year = 1]] )

LOAD

...

Date,

Year(Yearstart(Date, 0, 4)) as FiscalYear,

From ...;

OR use

Yearname(Date, 0, 4) as FiscalYear,

With a different formatting (2011-2012) then before (2011).

In both examples, I used April (first_month_of_year=4) as start of the fiscal year.

Hope this helps,

Stefan

shanmurugesh
Not applicable

how to calculate financial year start date from given date in qlikview

Hi,

yes..its is working..

Thanks

Murugesan.N.

Not applicable

Re: how to calculate financial year start date from given date in qlikview

Thank you so much. This is really helpful.