topic Re: X axis date formatting on chat. in QlikView

X axis date formatting on chat.

Fri, 06 Jul 2012 20:12:16 GMT

I have below dates on X-axis

How to format these in Month-yyyy format or dd-mm-yyyy format.

Thanks in advance for help.

MayilVahanan — Fri, 06 Jul 2012 20:23:11 GMT

Hi,

In Script,

You can change like this,

Load *,Month(Date) & ' -' & Year(Date) as MonthYear from tablename;

Month('08/14/2011') & ' -' & Year('08/14/2011') gives Aug-2011

Hope it helps

Fri, 06 Jul 2012 20:50:52 GMT

Thanks formated my axis using your below suggestion-

Month('08/14/2011') & ' -' & Year('08/14/2011') gives Aug-2011