Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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