Discussion Board for collaboration related to Creating Analytics for QlikView.
Below is my bar chart:
This the expression I use : =SUM(QA1)/Count(QA1)
Can I show the total average in same bar chart?
Go to Solution.
Check the attached:
Total Average of the three bars?
May be add a reference line with this expression:
Avg(TOTAL Aggr(SUM(QA1)/Count(QA1), DimensionNameHere))
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.
I understand what you want, can you share raw data to show you how it can work
Attached is the QVW.
It is frustrating :-D
You are simply the best.. :-D
Many many Thanks,