Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner
Partner

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
Master II
Master II

try this

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

here TempDate is my fieldname

Not applicable

Hi ,

     You can try the below code.

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

Please let me know if there is anything.

//yusuf

jagan
MVP & Luminary
MVP & Luminary

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.