Sort expression for "self-created" dimensions in pivot

[Yakuz]

 

Hi all,

I am using Qlik Sense for a month now and we are on a good way to become friends. Unfortunately I still struggle with the logic sometimes. I have created new dimensions with an "IF" function in pivot table as columns, which are not related to one field. my Dimensions:

(=IF(Match(testModule, 'Main City') OR Match(testModule, 'Smaller City') AND Match(KPI_Location,'City Group'),'Main&Smaller City',)

IF(Match(testModule, 'Highways'), 'Highways',

IF(Match(testModule, 'Smaller City'), 'Smaller City)')))

Therefore I would like to sort dimensions in this order as columns:

1. Main&Smaller City |  2.Smaller City |  3.Highways

How do you sort self-defined dimensions, which have if-conditions (with 1-3 parameters) and which are not related to one field. 

I tried to sort them with Match but somehow I am not using the right path.. 😞 what would be the easiest way?

(This is just an extract to put total 11 dimensions/columns in a customized order, desc or asc dont work..)

kind regards,

yakuz