Discussion board where members can get started with Qlik Sense.
I'm trying to extract Month and Year from my given date format 14/12/2018 11:47:35
I've tried both Month(date_data) and Year(date_data)
but getting null value with in my table after i loaded the script.
try like this:
Year(Timestamp#('14/12/2018 11:47:35','DD/MM/YYYY hh:mm:ss')) as YearMonth(Timestamp#('14/12/2018 11:47:35','DD/MM/YYYY hh:mm:ss')) as Month
replace '14/12/2018 11:47:35' with your Timestamp Field
View solution in original post
Year(Floor(Datefield)) as year
Month(Floor(Datefield)) as Month
Oh thanks this worked!