Create an graph chart order by 1, 2, ..., '360 forward'
Hello Qlik community. I would like to ask for some help.
I am creating a report that creates some sort of Aging of the time elapsed between a good receipt and an invoice receipt. The information comes partially from Excel. The aging classification is 1, 7, 15, 30, 60, 90, 120, 180, 360, 360 forward. When I did that, the 360 forward part put it at the beginning of the chart. So later I tried to convert it to text, but this happens (image).
Try creating the classification values using the dual function so they get a numeric value and a textual format. Give 360 forward a numeric value that's larger than 360 and the text value '360 forward'. Then you can sort the classification value numerically to get the sort order correct.