Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. 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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
Highlighted

HI

Try like this

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

Hope it helps

Thanks & Regards,
Mayil Vahanan R

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

Not applicable

That works perfectly, thank you