topic Chart X axis number formatting in QlikView https://community.qlik.com/t5/QlikView/Chart-X-axis-number-formatting/m-p/1285210#M862622 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We have a QlikView document that shows a chart of Values by Week number.</P><P></P><P>The data is pulled from a SQL view that stores week number as YYYYWW (as in year * 100 + week number)</P><P></P><P>when plotted to a chart this looks a bit messy, so is there an easy way I can format this number to just show the last two digits (week), and keep the sort order as below?</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148585_Capture1.PNG" style="height: auto;" /></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Chart X axis number formatting https://community.qlik.com/t5/QlikView/Chart-X-axis-number-formatting/m-p/1285210#M862622 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We have a QlikView document that shows a chart of Values by Week number.</P><P></P><P>The data is pulled from a SQL view that stores week number as YYYYWW (as in year * 100 + week number)</P><P></P><P>when plotted to a chart this looks a bit messy, so is there an easy way I can format this number to just show the last two digits (week), and keep the sort order as below?</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148585_Capture1.PNG" style="height: auto;" /></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Chart-X-axis-number-formatting/m-p/1285210#M862622 Anonymous 2020-11-25T16:16:04Z Re: Chart X axis number formatting https://community.qlik.com/t5/QlikView/Chart-X-axis-number-formatting/m-p/1285211#M862623 <HTML><HEAD></HEAD><BODY><P>May be using Dual function</P><P></P><P><STRONG>Dual(Right(YearWeek, 2), YearWeek)</STRONG></P></BODY></HTML> Fri, 06 Jan 2017 16:51:26 GMT https://community.qlik.com/t5/QlikView/Chart-X-axis-number-formatting/m-p/1285211#M862623 sunny_talwar 2017-01-06T16:51:26Z Re: Chart X axis number formatting https://community.qlik.com/t5/QlikView/Chart-X-axis-number-formatting/m-p/1285212#M862624 <HTML><HEAD></HEAD><BODY><P>Thank you Dual solved it, a nice simple solution that saved me hours</P></BODY></HTML> Mon, 09 Jan 2017 09:28:15 GMT https://community.qlik.com/t5/QlikView/Chart-X-axis-number-formatting/m-p/1285212#M862624 Anonymous 2017-01-09T09:28:15Z