Qlik Community

New to Qlik Sense

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

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

Average Trendline in Bar chart in QlikSense

Hello,

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.

Qlikview: 

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
arulsettu
Master III
Master III

Can you share the sample app 

lironbaram
Partner
Partner

hi 

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