Chart X axis number formatting

[Anonymous]

Hi,

We have a QlikView document that shows a chart of Values by Week number.

The data is pulled from a SQL view that stores week number as YYYYWW (as in year * 100 + week number)

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?

Thanks

[sunny_talwar · Accepted solution]

May be using Dual function

Dual(Right(YearWeek, 2), YearWeek)

[Anonymous]

Thank you Dual solved it, a nice simple solution that saved me hours