
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
AOV in Grouped Bar Chart with two dimensions
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you share sample data with expected output?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
