topic Re: Create an graph chart order by 1, 2, ..., '360 forward' in QlikView

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

julioarriaga — Thu, 11 Aug 2016 16:00:31 GMT

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!

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

Colin-Albert — Thu, 11 Aug 2016 16:10:43 GMT

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

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

Gysbert_Wassenaar — Thu, 11 Aug 2016 16:14:36 GMT

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.