topic Re: Year Range in App Development

Year Range

Karahs — Mon, 23 May 2016 04:42:08 GMT

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 — Mon, 23 May 2016 05:11:56 GMT

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

pratap6699 — Mon, 23 May 2016 05:46:51 GMT

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 — Mon, 23 May 2016 06:31:40 GMT

Try this for a quick fix.

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

undergrinder — Mon, 23 May 2016 07:20:21 GMT

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

Karahs — Mon, 23 May 2016 11:57:40 GMT

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

Thanks