Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Deepak87
Partner - Contributor III
Partner - Contributor III

Need the multiple reference line in QlikSense Bar chart

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

Labels (1)
1 Reply
lorenzoconforti
Specialist II
Specialist II

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))