Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kshitijas
New Contributor III

Year Range

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

5 Replies
MVP
MVP

Re: Year Range

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

pratap6699
Contributor

Re: Year Range

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
Contributor II

Re: Year Range

Try this for a quick fix.

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

undergrinder
Valued Contributor II

Re: Year Range

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.

kshitijas
New Contributor III

Re: Year Range

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

Thanks