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.

Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Want to calculate Average instead of total in a BarChart and Straight table

Hi Team,

I want to display the average of all the months instead of total in the below bar chart(instead of total bar -average bar should appear).

This Average bar should appear as a bar after the months in the place of Total bar.

Please find the attached Sample Excel file and the sample QVW.

Kindly help me out in resolving this.



1 Reply

Hi, Joseph.

We simplify by reading the table with the Crosstable Syntax.

We can then simply have the expression as Avg(Value)

See the attached qvw.

Hope this answers your question