Qlik Community

New to Qlik Sense

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DaBigFella
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
Kushal_Chawda

Can you share sample data with expected output?

DaBigFella
Contributor
Contributor
Author

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