Create an graph chart order by 1, 2, ..., '360 forward'

[julioarriaga]

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).

Could anyone help me ?

Thank you!

[Colin-Albert]

define your dimension as a dual value so you have both text and numeric representation of the values. The dimension will display the text values sorted by the numeric value.

This post by Robert_Mika‌ has details on using Dual()  How to use- Dual()

[Gysbert_Wassenaar]

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.