Discussion Board for collaboration related to Creating Analytics for QlikView.
Is it possible to convert the below values in to fiscal year ...
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
Go to Solution.
May be this
Year(AddMonths(Date#(CMonth, 'YYYYMM'), 9)) as [Fiscal Year]
but i am getting any output .........
but i am not getting any output
Thanks Sunny for your reply its working