Discussion Board for collaboration related to QlikView App Development.
I would like to create a date because i only have the YEAR on my field and i would set the date 01/01/YEAR for example, and convert to integer this date into my field AsOf.
The AsOf field:
How can i do that please ?
Thanks you in advance for your help.
MakeDate(YEAR,1,1) AS AsOf_Date
To make it a number:
Num(MakeDate(YEAR,1,1)) AS AsOf_Date
View solution in original post
try like this
date(YEAR) as AsOf
you will get date field
then you can derive year from that
year(AsOf) as year
Thanks a lot it works perfectly !