Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to display fiscal year

hi

i have a query fiscal year(2013Q1) this formate,

i want to change fiscal year(FY13) this formate

plz help me,

Thanks,

4 Replies
peschu123
Contributor III

Re: How to display fiscal year

Hi damodark,

please post some more details or sample data. It's not clear to me what you're going to do.

One shot in the dark... Take a look at mapping tables or perhaps this thread about master calender maybe helpful.

er_mohit
Honored Contributor II

Re: How to display fiscal year

try this

'FY' & Right( Year(TempDate),2) as YearQtr

here TempDate is my fieldname

Not applicable

Re: How to display fiscal year

Hi ,

     You can try the below code.

='FY'& Date( Date#( Left( '2013Q1',4),'YYYY') ,'YY')

Please let me know if there is anything.

//yusuf

MVP
MVP

Re: How to display fiscal year

Hi,

Try like this

='FY'&Mid('2013Q1', 3, 2)

Hope this helps you.

Regards,

Jagan.

Community Browser