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

cheburashka — Thu, 18 Apr 2013 09:23:47 GMT

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

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

cheburashka — Wed, 24 Dec 2014 14:21:10 GMT

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

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

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

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