This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i am having data like this
i did the following
month(SubField(Year,'/','1')) as newmonth,
Year(SubField(Year,'/','1')) as newyear;
but not getting the result
Month(Date#(Year, 'MM/YYYY')) as Month
Year(Date#(Year, 'MM/YYYY')) as Year
View solution in original post
Month(Date#(SubField(Year,'/','1'),'MM')) as newmonth,
SubField(Year,'/','2')) as newyear;
Left(Year,2) will give month and
Right(Year,4) will give year
I would say it because you are just present the number and asking from the month or Year.
Normally you would use them to strip out a month or year from a date. so maybe try
Month(DATE(Year,MM/YYYY)) AS Newmonth,
Taking out the Month() and Year() functions should work to.
Left(Year,2) as Newmonth,
Right(Year,4) as Newyear
month is fine
year i am having 2015,2016
but result is
2001 to 2012
I have changed it.
i will try and get back
Month(Date#(MonthYearField,'MM/YYYY')) as Month,
Year(Date#(MonthYearField,'MM/YYYY')) as Year