topic Specific Sort Order in App Development

Specific Sort Order

CBoardy — Fri, 24 Feb 2023 17:11:23 GMT

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

Re: Specific Sort Order

joaopaulo_delco — Fri, 24 Feb 2023 18:39:03 GMT

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,...

Re: Specific Sort Order

rwunderlich — Sat, 25 Feb 2023 18:22:39 GMT

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