Need the multiple reference line in QlikSense Bar chart

Deepak87 — Sat, 16 Nov 2024 03:10:49 GMT

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

Re: Need the multiple reference line in QlikSense Bar chart

lorenzoconforti — Tue, 25 Feb 2020 13:43:21 GMT

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

topic Need the multiple reference line in QlikSense Bar chart in App Development

Need the multiple reference line in QlikSense Bar chart

Re: Need the multiple reference line in QlikSense Bar chart