Discussion Board for collaboration on QlikView Layout & Visualizations.
i have a query fiscal year(2013Q1) this formate,
i want to change fiscal year(FY13) this formate
plz help me,
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.
'FY' & Right( Year(TempDate),2) as YearQtr
here TempDate is my fieldname
You can try the below code.
='FY'& Date( Date#( Left( '2013Q1',4),'YYYY') ,'YY')
Please let me know if there is anything.
Try like this
='FY'&Mid('2013Q1', 3, 2)
Hope this helps you.