Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have year coloumn ie. 2014,2015,2016 and i want the year to be displayed as :
2013-2014
2014-2015
2015-2016
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.
Thanks
There are a wealth of articles and discussions here on managing fiscal periods on Qlikview. Have you searched here yet?
If(year='2011','2010-2011' ,
If(year='2012','2011-2012',
if(year='2013','2012-2013',
if(year='2014','2013-2014',
If(year='2015','2014-2015',year)))))as newyear,
Try this for a quick fix.
=IF(Match(Month, 'Jan','Feb','Mar'),Year-1 & '-' & Text(Year),Year & '-' & Text(Year+1))
Hi Kshitja,
Try this:
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
G.
Thank You everyone for replying but i just used the class() and i got the output.
Thanks