Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
cheburashka
Contributor III

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

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

1 Solution

Accepted Solutions
cheburashka
Contributor III

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

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

View solution in original post

1 Reply
cheburashka
Contributor III

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

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

View solution in original post