AOV in Grouped Bar Chart with two dimensions

[DaBigFella]

Hello,

I am relatively new to Qlik Sense and I've run into a bit of a problem with a grouped bar chart. The chart has two dimensions, Section and Country, and one measure which is Average Order value (AOV).

The appearance of the graph (the grouping) is as I would like, however as you can see from the attached screenshot, the AOV for each country in each section is the same, which is incorrect. I am trying to show the AOV for each individual country within each individual section (Domestic Builder, Electrical etc.).

I have tried using:

=Avg(Aggr(Avg(DocTotal - VatSum), Country, Section))

and

=Aggr(Avg(DocTotal - VatSum), Country, Section)

but with no joy.  I've also tried using a very long If statement with every combination of Section and Country but this didn't work either. I'm not sure if I should be using Set Analysis instead.

Any suggestions, help or advice would be very much appreciated.

Thank you all in advance,

DaBigFella

[Kushal_Chawda]

Can you share sample data with expected output?

[DaBigFella]

Hi Kush, thank you very much for your reply.

I have attached a document containing a small amount of randomised data, as well as a bar chart mock-up showing the kind of outcome I want to achieve.

I am pulling data from three different tables for this, basically orders, items and location data.

I hope this helps and thank you again.

Kind regards,

DaBigFella