Need the multiple reference line in QlikSense Bar chart

[Deepak87]

Hi All,

We have requirement to show the two average amount reference lines in the bar chart.
Dimension used are Quarter
Measure : Amount

1. One for over the Quarters

2. Quarters Avg for each year

I was able to create the reference line for Avg(amount) over the years. But not able find the solution for second one. is it possible to do so?
Attached the screenshot for reference

[lorenzoconforti]

If I understand correctly, you want the quarters avg reference line to change for every year (as per your picture)

I don't believe you can do it with a reference line as they only allow one value to be displayed

You can solve your problem by using a combo chart where the second expression (i.e. the line you want to draw) is based on an aggregation by year

Something like this:

Dimension: Quarter

1st measure (bars): sum(Amount)

2 measure (line): avg(aggr(avg(Amount), Quarter))