Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total of barchart

Hello All,

Below is my bar chart:

This the expression I use : =SUM(QA1)/Count(QA1)

Can I show the total average in same bar chart?

Many Thanks,

Hasvine

1 Solution

Accepted Solutions
sunny_talwar

Check the attached:

Capture.PNG

View solution in original post

6 Replies
sunny_talwar

Total Average of the three bars?

May be add a reference line with this expression:

Avg(TOTAL Aggr(SUM(QA1)/Count(QA1), DimensionNameHere))

Not applicable
Author

Hi Sunny,

Does not work,

I need just 1 more bar to chow me the total average but it keeps on giving me a bar for each dimension.

Many Thanks,

Hasvine

sunny_talwar

I understand what you want, can you share raw data to show you how it can work

Not applicable
Author

Hi Sunny,

Attached is the QVW.

It is frustrating 😄

Many Thanks,

Hasvine

sunny_talwar

Check the attached:

Capture.PNG

Not applicable
Author

You are simply the best.. 😄

Many many Thanks,

Hasvine