I have a bar chart.
Dimensions are: week and location.
Expression = avg(duration)
![bar.png](/legacyfs/online/77441_bar.png)
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.