Bar chart with sub groups

[shr3k]

HI all. I am just starting to work with QlikView.

I need to create a Bar Chart with grouping, as in the example https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Visualizations/Bar-C...

I use the same data as from the example. When I add the Product Sub Group as a dimension to the chart, the sorting by Sales is reset and I can’t return it. For some reason, the Product Group field is set for sorting by default and I’m not able to change it. Screen with an example attached.

How to return sorting by sales in this case?

[Lisa_P · Accepted solution]

Go into the sorting, Product Group and select Custom sort by expression and add the Sales expression descending

[shr3k]

It works! Thank you!
I also found a training video on this test data, it may be useful for someone else.