Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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

Could anyone help me ?

Thank you!

Captura.PNG

2 Replies
Highlighted

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

Highlighted
MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand