Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Karahs
Partner - Creator
Partner - Creator

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
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
pratap6699
Creator
Creator

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

Try this for a quick fix.

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

undergrinder
Specialist II
Specialist II

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
Partner - Creator
Partner - Creator
Author

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

Thanks