Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

2 Replies
Highlighted
MVP
MVP

Can you share sample data with expected output?

Highlighted
Contributor
Contributor

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