topic Re: Financial Year Doubt in QlikView

Financial Year Doubt

Mon, 01 Sep 2014 04:45:30 GMT

Hi All,

I have Month Year like(Apr-14).

Date filed name is 'Item'

I used this

Date(yearstart(Item,0,4),'YYYY') as FIN_YEAR,

if(num(month(Item))<4,num(Month(Item))+9,num(Month(Item))-3) as FIN_MONTH_NUM,

'Q'&Ceil(if(num(month(Item))<4,num(Month(Item))+9,num(Month(Item))-3)/3) as FIN_QTR,

Month(Item) as FIN_MONTH,

Date(Item, 'MMM-YYYY') as FinancialYear,

I want the Fiscal Year as Apr11-Mar12, Apr12-Mar13, Apr13-Mar14 year wise

How to do this please help me?

Thanks in advance

PrashantSangle — Mon, 01 Sep 2014 04:48:56 GMT

Hi,

Use YearName()

like YearName(Item,0,4) as FinancialYear

Regards,

jagan — Mon, 01 Sep 2014 05:14:03 GMT

Hi Sandeep,

Try like this

LOAD

Date(YearStart(Item,0,4), 'MMMYY') & '-' & Date(YearEnd(Item,0,4), 'MMMYY') AS FIN_YEAR

FROM DataSource;

Regards,

Jagan.

PrashantSangle — Mon, 01 Sep 2014 05:39:27 GMT

Hi,

Try this also,

MonthName(YearName(Item(),0,4))&'-'&MonthName(YearName(Item(),1,3))

Regards,