Year Range

[Karahs]

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

[jonathandienst]

There are a wealth of articles and discussions here on managing fiscal periods on Qlikview. Have you searched here yet?

[pratap6699]

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,

[anagharao]

Try this for a quick fix.

=IF(Match(Month, 'Jan','Feb','Mar'),Year-1 & '-' & Text(Year),Year & '-' & Text(Year+1)) 

[undergrinder]

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.

[Karahs]

Thank You everyone for replying but i just used the class() and i got the output.

Thanks