Sort by Expression for the second dimension in grouped bar chart
I have a grouped bar chart with two dimensions in QlikSense. The first dimension is 'YEAR', so that gets easily sorted numerically.
The second dimension has string values and I need that in a specific order against the years. I have tried using functions like DUAL, MATCH, IF but nothing has worked out so far. However, if I filter out a specific YEAR, the sorting seems to work as desired (with MATCH function). Can anyone tell me what I'm doing wrong here? Thanks!