2 Replies Latest reply: Oct 3, 2017 4:15 PM by Fei Xu RSS

    Sort by Expression for the second dimension in grouped bar chart

    Adwitiya Borah

      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!