Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
Kmilla
Contributor
Contributor

Reference line with average over year

Hello everyone,

I have a bar chart representing my volumes for each month-year. I want to add a reference line representing the average level of my volumes for the current year. I have been trying a lot with functions avg, rangeavg, aggr, but still I can't find the solution.

I tried (unsuccessfully) for example :

RangeAvg(volumes,[date.autoCalendar.Year]=year(now()))

avg(aggr(volumes, [date.autoCalendar.Year]=year(now())))

Thanks in advance !

Labels (3)
1 Solution

Accepted Solutions
ChiragPradhan
Creator II
Creator II

Hi,

See attached.

If it is what you are looking for, consider marking it as resolved.

 

View solution in original post

1 Reply
ChiragPradhan
Creator II
Creator II

Hi,

See attached.

If it is what you are looking for, consider marking it as resolved.