Sort inside groups in Bar charts

[#1]

I have a bar chart.

Dimensions are: week and location.

Expression = avg(duration)

The chart is sorted by the Week. But the Location soring inside the week does not work as expected.

The Location sort order is done with the same expression =avg(duration), but you can see the result.

Actually, the Location order repeats exactly the order in the table: Location on avg(duration).

How can I force Qlikview to sort inside the weeks?

Thanks.