Discussion Board for collaboration on QlikView Layout & Visualizations.
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:
Message was edited by: Koen Bal
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:
View solution in original post