Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi,
yes..its is working..
Thanks
Murugesan.N.
Thank you so much. This is really helpful.
Thank you, it was helpful.