Question about visualization

[John5]

Hi

I have been asked by a customer to create a chart just like this exemple below. 

The blue bars would be something like Sum({<Type={'Team A'}>}Sales) per year per team.
The yellow  would be an average "line". Something like Avg(Total Sum(Sales)) per year for all teams together.
And there are about ten teams.

I need to know if this is possible to achieve in Qlik Sense without using any extensions. If not, I have to suggest a different way of presenting the data. This is what the customer wants, but if it is not possible...

Thanks

[Or · Accepted solution]

Try using a Bullet Chart (though you can also get something similar with a Combo Chart using a symbol in place of the yellow line). You may also want to consider using a Trellis Container for the team aspect (though if it's just ten, you could create ten objects if you prefer).

These are all native to Qlik / Qlik Bundle objects.