Qlik Community

New to Qlik Sense

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

Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Average Trendline in Bar chart in QlikSense


In Qlikview we have an option to show average trendline in bar chart for an expression without writing any separate expression for trendline, but in qliksense same option is not available to show trendline.  and also in qlikview the average is calculating based on the values shown on X.


Dim: Month  Expr: Count (distinct User) 

QlikSense: used same dim and expression, user below expression in reference line.

avg(aggr(Count(distinct User),Month))

Unable to get any line in chart.

Please help me with the expression to show the average value in bar chart. attached screenshot for reference.

Labels (2)
2 Replies
Master III
Master III

Can you share the sample app 



what type of bar chart do you use , it doesn't seem like the qlik sense built in chart 

just played with qlik sense built in chart used an expressions similar to the one you used 

and everything work fine 

or can you post a sample app with data