Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

Not applicable

Financial Year Doubt

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

Tags (2)
3 Replies

Re: Financial Year Doubt


Hi,

Use YearName()

like YearName(Item,0,4) as FinancialYear

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
MVP & Luminary
MVP & Luminary

Re: Financial Year Doubt

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.

Re: Financial Year Doubt

Hi,

Try this also,

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Community Browser