How to sort the values of a categorical - ordinal dimension on the axe of a chart?

[cheburashka]

Hello,

I would like to sort the values of a categorical - ordinal dimension in a specific order on the axe of a chart.

The values and the order are:

     Identify Opportunity    

     Qualification
     Quotation
     Decision
     Close

When these values are plotted on the axe they are by default plotted in a alphabetical order.

Close
Decision

Identify Opportunity

Qualification

Quotation

Which is not the order I want. I can change the order in properties>sort > expression.
But what expression should I use?

Thx for your advice, Koen

Message was edited by: Koen Bal

[cheburashka · Accepted solution]

A solution can be found in attachment.

Summary: By using the dual function you can give both a string value and a rank (number) to one record. In the frontend it is then possible to sort based upon numeric value.

More info about this approach can be found on the following blogpost:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/07/18/dual-exists-useful-functions