Specific Sort Order

[CBoardy]

Hi All,

I want to sort one dimension (a) in a very specific way. I had the idea of creating an extra Column(b) in the dataset ascending in value ie 1, 2, 3,....4 labelling the row I want at the top 1 and somehow putting in a few lines that sort dimension (a) buy the newly added column. Is there a more "proper" way to do this like is there a way to specifically order dimension (a) by actually listing the values in the order I want? 

Many thanks

[joaopaulo_delco]

Hi @CBoardy , you can do the way you mentioned. Adding a extra column and inside the sort properties you define the  order by this extra column.

Other way to do that is defining  a sort propertis by expression like this (do it like this only if you have little data):

if(yourDimension='text1',1,
if(yourDimension='text2',2,
if(yourDimension='text3',3,...

[rwunderlich]

You can do a dummy load of the dimension to establish the sort order. See 

https://qlikviewcookbook.com/2012/11/establishing-a-sort-order/

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com