Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
Showing results for 
Search instead for 
Did you mean: 

AOV in Grouped Bar Chart with two dimensions


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))


=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,


Labels (4)
2 Replies

Can you share sample data with expected output?


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,