Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

how to convert yearmonth in to fiscal year

Hello,

         Is it possible to convert the below values in to fiscal year ...

CMonth

201604

201605

201606

201607

when it come to fiscal year all the above values are FY2017

Expression i tried :

                          year(addmonths(CMonth,9)) as Fiscal Year

but i am getting any output ..

is there any other way to write this expression

thanks

1 Solution

Accepted Solutions

Re: how to convert yearmonth in to fiscal year

May be this

Year(AddMonths(Date#(CMonth, 'YYYYMM'), 9)) as [Fiscal Year]

3 Replies
kunkumnaveen
Contributor III

Re: how to convert yearmonth in to fiscal year

but i am getting any output .........

but i am not getting any output

Re: how to convert yearmonth in to fiscal year

May be this

Year(AddMonths(Date#(CMonth, 'YYYYMM'), 9)) as [Fiscal Year]

kunkumnaveen
Contributor III

Re: how to convert yearmonth in to fiscal year

Thanks Sunny for your reply its working

Community Browser