topic Re: Chart and Graph formatting in QlikView

Chart and Graph formatting

Thu, 29 Aug 2013 14:21:44 GMT

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

MayilVahanan — Thu, 29 Aug 2013 14:23:38 GMT

Try like this

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

Hope it helps

CELAMBARASAN — Thu, 29 Aug 2013 14:26:47 GMT

Better you can create a field in script itself.

or try with this in charts

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

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

Hope it helps

Thu, 29 Aug 2013 14:26:48 GMT

That works perfectly, thank you