Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Chart and Graph formatting

Hello everyone,

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,

Simon

1 Solution

Accepted Solutions
Highlighted

HI

Try like this

= Date(Datefield, 'MMM YY') as dimension

Hope it helps

View solution in original post

3 Replies
Highlighted

HI

Try like this

= Date(Datefield, 'MMM YY') as dimension

Hope it helps

View solution in original post

Highlighted

Better you can create a field in script itself.

or try with this in charts

=Date(MonthStart(DateField), 'MMM YYYY')

or

=Month(DateField) &' ' & Year(DateField)

Hope it helps

Highlighted
Not applicable

That works perfectly, thank you