Discussion board where members can get started with QlikView.
I have a date field with the data showing as follows: 20180927
I would like to create another 2 fields for Year and Month
Year should be ‘2018’
Month should be ‘Sep’
May be this
Year(Date#(DateField, 'YYYYMMDD')) as Year,
Month(Date#(DateField, 'YYYYMMDD')) as Month,