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',)