Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Yakuz
Contributor
Contributor

Sort expression for "self-created" dimensions in pivot

 

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

MainSmallerCitySort.PNG

Labels (1)
0 Replies