Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have year like 11-12, 12-13, 13-14, 14-15
I want to show it like FY 12, FY 13, FY 14, FY 15
kindly help
Try like:
Load
'FY ' &SubField(YourYearField, '-',2) as NewYear
Hi,
Look at this post
http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year
Fiscal and Standard Calendar generation
regards
ASHFAQ
can I do it on front end??
Yes you can.
Regards
KC
HOW?
same expression of tresesco
'FY ' &SubField(YourYearField, '-',2)
Hi,
write this as expression in a straight chart and name it as New Year
='FY ' &SubField(YourYearField, '-',2)
Rgards
KC