Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

X axis date formatting on chat.

I have below dates on X-axis

  • 08/14/2011
  • 07/09/2011
  • 06/08/2011
  • etc.

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

Thanks in advance for help.

1 Solution

Accepted Solutions

Re: X axis date formatting on chat.

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

2 Replies

Re: X axis date formatting on chat.

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

Not applicable

Re: X axis date formatting on chat.

Thanks formated my axis using your below suggestion-

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

Community Browser