I am experiencing an issue where qlik will not sort any of my measures. I need this chart to show this descending by employees in Workday, but it will not respond to sorting. I have tried in the right hand side panel as well, using auto and custom but it still will not sort in the chart.
this "isssue" is due to RowNo function. "Sorting on y-values in charts or sorting by expression columns in tables is not allowed when RowNo() is used in any of the chart's expressions. These sort alternatives are therefore automatically disabled."
So if you apply colors, sorting on measures will be disabled.