topic Re: Dates in DD-MMM-YY format rather than Number in QlikView https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676446#M245513 <HTML><HEAD></HEAD><BODY><P>It works. Thanks for the reply.</P></BODY></HTML> Wed, 22 Oct 2014 15:37:28 GMT 2014-10-22T15:37:28Z Dates in DD-MMM-YY format rather than Number https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676442#M245509 <HTML><HEAD></HEAD><BODY><P>I have attached the simple qvw file and I am trying it to show date in x- axis in 'DD-MMM-YY' form rather than number. And i want it to be continuous variable. Is there a way to format the x- axis field to show the date in regular format keeping everything the same?</P></BODY></HTML> Wed, 22 Oct 2014 15:15:15 GMT https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676442#M245509 2014-10-22T15:15:15Z Re: Dates in DD-MMM-YY format rather than Number https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676443#M245510 <HTML><HEAD></HEAD><BODY><P>Yes - go to the number tab of the chart properties. Select the 'continuous x axis&nbsp; field and change the format to date. Edit the date pattern to DD-MMM-YY on the right.</P></BODY></HTML> Wed, 22 Oct 2014 15:18:55 GMT https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676443#M245510 JonnyPoole 2014-10-22T15:18:55Z Re: Dates in DD-MMM-YY format rather than Number https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676444#M245511 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try to change it in the calculated dimension</P><P>date(yourdate,'DD-MMM-YY')</P></BODY></HTML> Wed, 22 Oct 2014 15:23:03 GMT https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676444#M245511 2014-10-22T15:23:03Z Re: Dates in DD-MMM-YY format rather than Number https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676445#M245512 <HTML><HEAD></HEAD><BODY><P>I tried this but it didn't work. Thanks for the reply</P></BODY></HTML> Wed, 22 Oct 2014 15:36:57 GMT https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676445#M245512 2014-10-22T15:36:57Z Re: Dates in DD-MMM-YY format rather than Number https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676446#M245513 <HTML><HEAD></HEAD><BODY><P>It works. Thanks for the reply.</P></BODY></HTML> Wed, 22 Oct 2014 15:37:28 GMT https://community.qlik.com/t5/QlikView/Dates-in-DD-MMM-YY-format-rather-than-Number/m-p/676446#M245513 2014-10-22T15:37:28Z