topic Academic year construction in QlikView

Academic year construction

Wed, 10 Jun 2009 11:14:49 GMT

I have field date in format dd/mm/yyyy; I have date from 01/05/2004 to 30/04/2009 in records; The function Year(date) give me the year value; My problems is my Acadamic year starts from May2004 to April2005; May2005 to April2006 likewise..... How I can have AYear(Acadmicyear), 2004,2005... by selecting the date with above criteria. I am New to qlikview. Thanks

Academic year construction

Wed, 10 Jun 2009 11:26:32 GMT

Hi,

You are saying abt finianacial year rite...?

In that case you should go for yearname() function.

= Yearname(Fieldname,0,5) as Financial_Year

- Sridhar

Academic year construction

amars — Wed, 10 Jun 2009 12:11:58 GMT

Hi,

You will need to creat an alias for that in this way

Load Year(addmonths (DateField,-3)) as financialYear Resident RequiredTable;

The simplest logic for this is that for financial year 2009 the date values are Apr 2009 to Mar 2010 , so to get the proper financial year deduct 3 month's from the datefield & use if with a different alias. Likewise you can use it for your requirement.

See if it helps.

Regards

Amar

Academic year construction

Sun, 14 Jun 2009 15:19:05 GMT

IF (NUM(MONTH(ENROLLDATE) ) <5, (YEAR(ENROLLDATE)-1, YEAR(ENROLLDATE)) AS ACDAMICYEAR,

GIVES ACDAMICYEAR FROM MAY 2007 TO APRIL 2008

HAPPY SHARING