Community
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi all,
I have the field Year and month ...i have concatenated the both and created the field example :2019-09
Now i want to convert this in date format and also i want to generate date as well...as it has no date values ,like 1,2,3 ,4//etc.
Can anyone help me in this.
Please generate the Calendar for your field, For now - Simplify using this
Date(Date#(FieldName, 'YYYY-MM'))
Or
=MakeDate(Year(Date#(FieldName, 'YYYY-MM')),Month(Date#('2019-09','YYYY-MM')))
