Qlik Community

Ask a Question

New to QlikView

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Average In Bar Chart

Hi all,

 

Im sure this is simple but just cannot figure it out....

So my problem is,

I have a bar chart showing the lowest sales and the highest sales- however i want an average line (same as per image)

however i want the actual average figure to display ad not 'y=2.0185e+006, R=3.3....' i want actual average, 

How could i achieve this using a calculated method:

this is my current calculated expression"sum(Fund_Amount_Dec)-sum(Fund_Amount_Nov)" now i just want the average amount to display without clicking Average under expression as this does not give the actual average correctly

2 Replies
Specialist III
Specialist III

Hi,

 

have you tried to create Reference line by using Avg function?

can you attach sample data with expected output?

 

Contributor
Contributor

Hi,

 

Te expected output would same as attached image ,

 

How would i create a ref line using avg,

Apologies i am fairly new and still learning 

 

Thank You