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

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.

Thanks&Regards,

Hari

1 Reply
simenkg
Specialist
Specialist

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

Regards

SKG