Quarters bar chart, each with their own Reference Lines

[#1]

Hello Qlikcommunity,

I have a bit of a dilemma. My requirements are that they would like to see each bar separately with each bar having their own (three) reference lines.

Ideally we wanted it in a bar chart, with a slider across time periods, with each bar having their own three lines.

Now when I put this into a bar chart, the reference lines get calculated and averaged together. We have tried to use plateau lines but because those lines start in the middle of each bar it was confusing to read.

We also tried to trellis the charts, but the trellis has a sizing bug and the reference lines would be averaged together for all the quarters.

My question: Is it even possible to display the information in this way.

The closest I have come is four charts in a container, with each chart having their own reference lines. (Seen below). The problem is that we can't see Q4 of one year, and Q1 of another year, and the scales get all messed up from chart to chart.

We'd prefer not to do the container method and use a method that uses a bar chart which we can control with time sliders. Any help would be appreciated.