I have year coloumn ie. 2014,2015,2016 and i want the year to be displayed as :
and the month will start from April
ie. 2013(April) - 2014(March)
I only want the year to be displayed as the format given above.
There are a wealth of articles and discussions here on managing fiscal periods on Qlikview. Have you searched here yet?
Try this for a quick fix.
=IF(Match(Month, 'Jan','Feb','Mar'),Year-1 & '-' & Text(Year),Year & '-' & Text(Year+1))
DateColumn & '-' & DateColumn+1 as period -> If the date format is 2014,2015,2016
Year(Date) & '-' & Year(DateColumn)+1 as period -> If the date format is date
Thank You everyone for replying but i just used the class() and i got the output.
Retrieving data ...