Discussion board where members can get started with QlikView.
Just a quick simple one, but I can't seem to find where to make the change.
I have months on the x axis of my chart, and want to change the format of the date to go from DD/MM/YYYY to MMM YY, how can I go about this?
With many thanks,
Try like this
= Date(Datefield, 'MMM YY') as dimension
Hope it helps
View solution in original post
Better you can create a field in script itself.
or try with this in charts
=Date(MonthStart(DateField), 'MMM YYYY')
=Month(DateField) &' ' & Year(DateField)
That works perfectly, thank you